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