The workbook has mutilple authors responsible for various sheets, so I cannot be assured to always know each sheet password
There are Protected sheets With and Without passwords
There are visible & xlveryhidden sheets
I want to set Protect UserInterFaceOnly:=True ONLY to VISIBLE worksheets WITHOUT a password
But I can’t figure out how to say ws. Password = ""
I tried to cancel the password popup window and resume next but that doesn’t work eitherPlease Login or Register to view this content.
Please Login or Register to view this content.
Bookmarks