Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hiding AddIn Methods from Worksheet Functions But Exposing to VBA | Excel Programming | |||
some 'Protection' questions | Excel Worksheet Functions | |||
Excel : Hiding/Locking Formulae | Excel Discussion (Misc queries) | |||
3 questions about automated c++ com add-in worksheet functions | Excel Worksheet Functions | |||
Protection and Hiding Sheets | Excel Discussion (Misc queries) |