View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
dd dd is offline
external usenet poster
 
Posts: 95
Default 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