How to disable or remove Save button.

Is it possible to disable the Save button automatically on the Excel
toolbar only when a particular workbook is opened?

I have problems with my forms being overwritten and formulas lost by
users clicking on the Save button rather than using File/Save As.

It doesn't seem to matter that the fields are locked and worksheets are
protected. It overwrites them anyways.

Any suggestions?

Jesse


---
Message posted from http://www.ExcelForum.com/

Hi,
I suggest you remove the commandbars menu and create
menu items that you want. eg: print, close, SaveAs, etc..

regards
Mark



-----Original Message-----
Is it possible to disable the Save button automatically
on the Excel
toolbar only when a particular workbook is opened?

I have problems with my forms being overwritten and
formulas lost by
users clicking on the Save button rather than using
File/Save As.

It doesn't seem to matter that the fields are locked and
worksheets are
protected. It overwrites them anyways.

Any suggestions?

Jesse


---
Message posted from http://www.ExcelForum.com/

.

Hi Jesse,

Well you could try to Delete a Save command from the menu bar.
Delete a button or menu command

You can rearrange and modify toolbar buttons, menus, and menu commands by
using the mouse or you can use the Rearrange Commands dialog box which is
accessible using a keyboard menu. These tasks are identified as (keyboard
accessible).

Do one of the following:

Delete a button

On the Tools menu, point to Customize, and then click Toolbars.
Make sure the toolbar you want to change is visible.
How?

In the Customize dialog box, click the Toolbars tab.
Select the check box for the toolbar you want to display.
Drag the button you want to delete off the toolbar.
In the Customize dialog box, click Close.
Delete a button (keyboard accessible)

On the Tools menu, point to Customize, and then click Toolbars.
Make sure the toolbar you want to change is visible.
How?

In the Customize dialog box, click the Toolbars tab.
Select the check box for the toolbar you want to display.
In the Customize dialog box, click the Commands tab.
Click Rearrange Commands.
Click Toolbar, and then click the toolbar that contains the button you want
to delete.
In the Controls list, click the button you want to delete.
Click Delete.
Delete a command from a menu

On the Tools menu, point to Customize, and then click Toolbars.
Click the menu (menu: A list of commands that is displayed when you click a
menu name on a menu bar or other toolbar.) that contains the command you
want to delete.
Drag the command you want to delete off the menu.
In the Customize dialog box, click Close.
Delete a command from a menu (keyboard accessible)

On the Tools menu, point to Customize, and then click Toolbars.
If the menu (menu: A list of commands that is displayed when you click a
menu name on a menu bar or other toolbar.) you want to change is on a
toolbar, make sure that the toolbar you want to change is visible.
How?

In the Customize dialog box, click the Toolbars tab.
Select the check box for the toolbar you want to display.
In the Customize dialog box, click the Commands tab.
Click Rearrange Commands.
If the menu you want to change is on the menu bar, click Menu Bar and then
click the menu you want in the Menu Bar list.
If the menu you want to change is on a toolbar, click Toolbar, and then
click the menu that you want in the Toolbar list. For example, click
Drawing|AutoShapes to add a command to the AutoShapes menu on the Drawing
toolbar.

In the Controls list, click the menu command you want to delete.
Click Delete.

See Also
Add a button, menu, or command

Restore original settings for menus, buttons, commands, or toolbars

For Further Information :
http://office.microsoft.com/assistan...010384941033&C
TT=1&Origin=EC790000701033&QueryID=1yo5rjSjn&Query =Delete+a+button+or+menu+c
ommand&Scope=TC%2cHP%2cHA%2cRC%2cFX%2cES%2cEP%2cDC %2cXT

Please let me know has this helped You...
Thank You...
Raghu...

Make the file open Read only -- then they have to save as rather than save


"jdtivoli " wrote in message
...
: Is it possible to disable the Save button automatically on the Excel
: toolbar only when a particular workbook is opened?
:
: I have problems with my forms being overwritten and formulas lost by
: users clicking on the Save button rather than using File/Save As.
:
: It doesn't seem to matter that the fields are locked and worksheets are
: protected. It overwrites them anyways.
:
: Any suggestions?
:
: Jesse
:
:
: ---
: Message posted from http://www.ExcelForum.com/
: