Password protection...

**dustyv** · 11-23-2006, 03:55 AM

Hello,
Can any of my peers on this forum please enlighten me as to;
Is there a method whereby excel can automatically be password protected (either workbook or worksheet or both) when closing?
What I am trying to achieve is (at least) an automatic notification (or reminder) to employ the password to protect when closing the workbook/sheet.
Appreciate your time and advice.

**davesexcel** · 11-23-2006, 07:30 AM

I have this code when openning a workbook......

Please Login or Register  to view this content.

I suppose you could use the code in a Workbook_close event

If you need to know where the different modules are go to this site

http://www.contextures.com/xlvba01.html#Workbook

**Bryan Hessey** · 11-23-2006, 08:03 AM

Originally Posted by davesexcel

I have this code when openning a workbook......

Please Login or Register  to view this content.

I suppose you could use the code in a Workbook_close event

If you need to know where the different modules are go to this site

http://www.contextures.com/xlvba01.html#Workbook

Hi Dave,

the Workbook close event is good, otherwise simply disabling Macros will defeat your password.

---