ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Two questions on worksheet protection and hiding formulae/ functions (https://www.excelbanter.com/excel-programming/381750-two-questions-worksheet-protection-hiding-formulae-functions.html)

dd

Two questions on worksheet protection and hiding formulae/ functions
 
Is there a line of code that will hide all cell formulae/ functions?

Is there a way to adjust the following code to apply to only cells populated
with formulae/ functions?

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Formula < dtval Then Target.Formula = dtval
End Sub

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
dtval = Target.Formula
End Sub

'From
'http://www.dotxls.com/excel-security/27/how-to-protect-an-excel-sheet-with-vba-macro-code




All times are GMT +1. The time now is 10:46 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com