LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
canot remove command from FILE MENU EXCEL CUstomization Excel Discussion (Misc queries) 2 December 7th 04 01:10 AM
How can I add "File" to my menu? bambi Excel Discussion (Misc queries) 1 December 5th 04 06:31 PM
XML Source Menu Item disabled?? File version?? Jay Lauffer Excel Discussion (Misc queries) 1 December 3rd 04 10:23 PM
When I select "Open" from the "File" menu in Excel, I get only a . dan Excel Discussion (Misc queries) 1 November 30th 04 11:25 PM
How to remove an Excel Main Menu item inserted by .xla file Dennis Excel Discussion (Misc queries) 5 November 28th 04 08:39 PM


All times are GMT +1. The time now is 03:12 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"