PDA

View Full Version : Solved: Accessing specific sheet by password box



ioncila
04-22-2010, 02:41 PM
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
04-22-2010, 03:32 PM
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
04-25-2010, 05:15 AM
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
04-25-2010, 07:06 AM
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
05-03-2010, 02:38 PM
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