Dear All,
I would like to hide some of the sheets included in an Excel workbook. This is not a problem! I did it using VBA to ensure none can change anything.
I went through the project properties, ticked the "Lock Project" and entered my password. I saved it and closed excel.
I reopened it and checked, I wasn't encountered with password request when I opened the VBA project. Could you please help me?
I used Excel 2007
Thank's
you will need to close all instances of excel for the sheet to 'lock' for you, otherwise it still knows your allowed to view it and will not prompt for password.
If you liked my solution, please click on the Star -- to add to my reputation
If your issue as been resolved, please clearly state so and mark the thread as [SOLVED] using the thread tools just above the first post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks