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
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