Protect Worksheet with Password

[longbow007]

Hello, could someone please help me modify my code so that the user is prompted with a password inputbox to both protect and unprotect my worksheet named: Data. I am using Excel 2003.

Thanks,

Chris

Please Login or Register  to view this content.

[JBeaucaire]

You really want "users" to have to know passwords and then remove them and add them back in? Letting them do that will seriously give them the ability to lock YOU out of their sheet.

Wouldn't it be better to simply allow your macro to work on the sheet without unprotecting it?

To do that, put this macro into the ThisWorkbook module:

Please Login or Register  to view this content.

Be sure to put in the correct password, the red code is the part that makes the "Data" sheet able to run macros even though it's protected.

Once the macro is installed, save your sheet, close it, then reopen it, that will set the flag properly.

[longbow007]

Hi JBeaucaire, thank you so very much for your excellent suggestion - very much appreciated. I am experiencing a compile error: Ambiguous name detected: Workbook_Open.

It may be just me, but I entered your code in ThisWorkbook module and entered the password where you had the word: Password in blue text. I then, saved my workbook and closed it.

I am not sure why I get this is happening? Do I need to keep my original VBA code the same or do I need to delete all references to both protect and unprotect my worksheet?

Cheers,

Chris.

[longbow007]

Hi JBeaucaire - oops, my bad, I have fixed my problem up - all OK now. Thanks again for your help.

Cheers,

Chris.