![]() XDic.Add xCell.Address, xCell.FormulaR1C1 Private Sub Worksheet_SelectionChange(ByVal Target As Range) ![]() VBA code: hide formula but display result without protecting worksheet Dim xDic As New Dictionary In the Microsoft Visual Basic for Applications window, please copy and paste VBA code into the Code window. In the worksheet you need to hide formulas but displaying the results, please right click the sheet tab, and select View Code from the right-clicking menu.Ģ. To hide formulas but displaying results without protecting a worksheet, please do as follows.ġ. Hide formula but display result without protecting worksheet with VBA code This article is talking about hiding formulas but displaying results without protecting worksheet in Excel. In some cases, you may need to hide formulas in your worksheet for private. How to hide formula but display the result without protecting worksheet in Excel?
0 Comments
Leave a Reply. |