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
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:
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.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks