H
Hugo
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!
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!