Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Macro to modify Excel Menubar

Status
Not open for further replies.

achau

Technical User
Apr 16, 2001
34
0
0
GB
I don't seem to be able to find a way to modify existing Excel menubars. What I'd want to do is to disable the "Save" and "SaveAs" in the "File" menu but leave the other menu commands intact when a user opens a specific file. I have already got a macro that runs automatically on opening that file but I don't seem to be able to get this one step working. Can anyone help please? TIA.
Al
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top