Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
I've been using the following code to protect my sheets: Sub protectsheet() With ActiveSheet .Protect Password:="topsecret", UserInterfaceOnly:=True .EnableOutlining = True End With End Sub I'd like the sheets, once they have been protected, to have the outlining feature enabled, which holds true when I protect/unprotect the open file, but once I close out of the file and re-open it, it tells me that I cannot use the outlining features when it is protected. Any thoughts? Thanks! -- Hugo |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Unprotecting Sheets | New Users to Excel | |||
Unprotecting Sheets with VBA and IRM | Excel Programming | |||
Unprotecting Sheets | Excel Programming | |||
Unprotecting Sheets with VBA and IRM | Excel Programming | |||
unprotecting sheets | Excel Programming |