View Single Post
  #1   Report Post  
andy
 
Posts: n/a
Default Disable menu selection

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.