Password access to a sheet in excel 2000

[grego9]

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.

thanks

[QVeen72]

Hi,

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)

Regards
Veena

[grego9]

Thanks. Once again you have saved me hours! it worked perfectly.