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.