Solved: Accessing specific sheet by password box

[ioncila]

Hi

When I open a certain workbook, it goes automatically to sheet1.
In that sheet users must choose from 4 options:
1.Save as a new file (which will contain two specific sheets);
2. GoTo Archive (which stores similar files created from the first option);
3. Cancel (to close the file)
4. Update Master (to update or change data in certain sheets - only available to a file administrator).

What I'm trying to do is create a routine that, by clicking/choosing Update Master, the access to other sheets only be possible by a password enter.

Can this be done?

Thanks

[austenr]

Sure you can do it, but passwords on worksheet(s) or Excel in general are a waste of time. Too easy to crack. However in answer to your question please post your workbook.

[ioncila]

Hi
Been away for a while.
I attached a sample of my file with some notes expressing my issue and needs.
Moreover, I included a macro that I was trying to adapt to solve my issue.

Thanks for your prescious help
Ioncila

[lucas]

I made some changes. Always use option explicit at the top of every module, sheet, standard, thisworkbook, userform, etc.

I also left some notes that explain why you are having trouble getting your code to work with the button.

[ioncila]

Sorry for the late reply

I've been away working in a place with a poor net signal.

This is to thank you for the help. It works great and fill my needs.

Thank you very much

Ioncila