Workbook Protection of Display Size and Properties

[cpadude]

Hello. I have an Excel file and I am trying to protect it so that all other viewers can not change the size of the workbook when viewing (maximize, minimize, or resize) AND so they can not view the Properties of the file in: File->Properties. I know someone else has done this and I would like to do the same thing.

Thanks

[Paul]

To disable the control boxes (max/min/restore..) here's some info from Microsoft (pertains to XL2000, but will probably work with later versions as is or with some gentle massaging):

http://support.microsoft.com/kb/213502

As for disabling the File-Properties menu, try this:

Sub HidePropItem()
    Application.CommandBars("Worksheet Menu Bar").FindControl _
    (ID:=750, Recursive:=True).Enabled = False
End Sub

If you do this, make sure that the workbook's close event restores the Properties menu, otherwise it will stay hidden for all workbooks you (and other users) use. Simply change .Enabled = False to .Enabled = True.