Excel Workbook level protection 1

[scroce]

On the close of my workbook, I want to enable workbook level protection in order to keep users from changing the names of my worksheet tabs if they open it with macros disabled.

I tried:

Private Sub Workbook_BeforeClose(Cancel As Boolean)

ActiveWorkbook.Protect ("MyPassword"), Structure:=True, Windows:=False

End Sub

but excel doesn't seem to recognize this command on this event. Does anyone know how to do this?

Q: Why is my computer doing that?
A: Random Perversity of Inanimate
Objects

 

[neilkonitzer]

If the users have macros disabled, then your code would never run irregardless. Neil Konitzer
Freisoft

http://www.freisoft.com

 

[acron]

Set all your worksheets (except a cover sheeet) to xlVeryHidden when closing the, and have a macro run to unhide the sheets on opening. If macros are disabled the sheets will not be available when the file is opened, and you can have a message to that effect on th ecover sheet.

A.C.