By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,285 Members | 2,147 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,285 IT Pros & Developers. It's quick & easy.

Password access to a sheet in excel 2000

P: 63
Is it possible to create a macro that prompts the user to enter a password to access a specific sheet in Excel 2000?

I can protect a sheet - but I cannot get a password prompt if the user tries to access the sheet.

May 16 '08 #1
Share this Question
Share on Google+
2 Replies

Expert 100+
P: 1,445

Check This Link

With a little bit tweaking of code, you can do it..
Also note: Security Level should be Low (Otherwise, the Macro will not be enabled)

May 16 '08 #2

P: 63
Thanks. Once again you have saved me hours! it worked perfectly.
May 16 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.