Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I would like to accomplish two things:
I have a password protected (both file, and modify levels) shared workbook (Office 2000). 1) I would like to disable the ability for anyone to "Accept/Reject" changes (Tools|Track Changes|Accept/Reject Changes drop down menu). Can I set a macro to run when the file opens to do this? and password protect the vb code, so that only I could potentially go into this? Please tell me what code I need to disable this menu item, or if there is a better way to do it. 2) Can I hide a column if the person entering the file is read-only? Please tell me what code I need to do this and where to put it. Thank you very much in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
canot remove command from FILE MENU | Excel Discussion (Misc queries) | |||
How can I add "File" to my menu? | Excel Discussion (Misc queries) | |||
XML Source Menu Item disabled?? File version?? | Excel Discussion (Misc queries) | |||
When I select "Open" from the "File" menu in Excel, I get only a . | Excel Discussion (Misc queries) | |||
How to remove an Excel Main Menu item inserted by .xla file | Excel Discussion (Misc queries) |