Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
error in attempt to warn about macro security
Hi,
I have the followign code ..... Private Sub Workbook_Open() Dim Sheet As Worksheet For Each Sheet In Worksheets If Sheet.Name < "waarschuwing" Then Sheet.Visible = xlSheetHidden End If Next Sheet Sheets("waarschuwing").Visible = xlSheetVeryHidden Set Sheet = Nothing end sub When the code is run, i get an error message: erro 1004 characteristic visible of class worksheet cannot be use any ideas? Pierre -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200511/1 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i get excel to warn me that i already used a certain value | Excel Discussion (Misc queries) | |||
Compile error in hidden module: security | Excel Programming | |||
need an error msge when I attempt to enter a duplicate value in a | Excel Discussion (Misc queries) | |||
Warn if already entered | Excel Worksheet Functions | |||
Macro Security Error No Macro | Excel Programming |