MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Disabled Save As


Posted by Mark on May 01, 2001 7:49 AM

I inherited a file at work from a coworker who disabled the save as function in excel. Does anyone know how that was accomplished and how can I get the save as function restored? Thanks.


Posted by Dave Hawley on May 01, 2001 8:23 AM


Hi Mark

Run this code:

Sub RestoreSaveAs()
Application.CommandBars("Worksheet menu bar").Controls _
("&file").Controls("&Save as...").Enabled = True
End Sub


Dave


OzGrid Business Applications

Posted by Mark on May 01, 2001 8:38 AM

I recieved this error when I ran the code. Any thoughts?
Invalid procedure call or argument (Error 5)


Posted by Dave Hawley on May 01, 2001 8:47 AM

Mark, is the "Save As" option under the "File" menu ? and if so is it greyed out ?

Dave
OzGrid Business Applications

Posted by Mark on May 01, 2001 8:51 AM

No it is not under the file menu and it is not hidden by the double drop down arrow that hides functions not commonly used.

Thanks again Dave

Posted by Dave Hawley on May 01, 2001 8:59 AM

Ok, i understand now, It's not disabled but rather not there at all.

Go to View>Toolbar>Customize Select "Worksheet Menu Bar" and click Reset. This will restore it back to it's default, which means any other Customization will be lost.

If still not there, go back to View>Toolbar>Customize and click the "Commands" tab. Select "File" and then drag the "Save as" command back onto the "File" menu.

DaveOzGrid Business Applications

Posted by Mark on May 01, 2001 9:07 AM

Thanks Dave

That worked thanks for your help Dave!