Hello,
While playing around with macros I'm getting errors when I try to protect the workbook. It's saying
Runtime error '1004'
"Unable to set the hidden property of the Range class"
The macro is opening hidden cells. Is there a way to protect all the cells except the cells that I want the users to use and still allow the macros?
Thanks for your help.
Nate
In your macro code, you can add a line at the beginning to turn off password protection, then at the end to turn it back on:
Please Login or Register to view this content.Since your password will be in plain text in the macro code, you should probably password protect the vba module from being viewed (in the vba window, click on Tools --> VBA Project Properties --> Protection)Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks