How to disable or remove Save button.

J

jdtivoli

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

I have problems with my forms being overwritten and formulas lost b
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 ar
protected. It overwrites them anyways.

Any suggestions?

Jess
 
M

Mark

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

regards
Mark
 
R

Raghu Prakash

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/assistance/preview.aspx?AssetID=HP010384941033&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...
 
W

Wouter

Hi Jesse,

An other solution is this:

Copy this code to a new module in VBE

' Start part 1
Option Explicit
Option Private Module

Sub ToggleSaveButton(ByVal blnToggle As Boolean)
Dim myBar As CommandBar
Dim myPullDown As CommandBarPopup
Dim myCommand As CommandBarControl

'
Set myBar = Application.CommandBars("Worksheet Menu Bar")
Set myPullDown = myBar.Controls(1)
Set myCommand = myPullDown.Controls(4)
myCommand.Enabled = blnToggle
myCommand.Visible = blnToggle
Set myCommand = Nothing
Set myPullDown = Nothing
Set myBar = Nothing

End Sub
'End part 1

Copy this code to the WorlBook in VBE:
'Start Part 2
Option Explicit

Private Sub Workbook_Activate()
Call ToggleSaveButton(False)
End Sub

Private Sub Workbook_Deactivate()
Call ToggleSaveButton(True)
End Sub
'End part 2

This code disables and hiddes the save button as soon as the workbook is opened.
The button unhiddes end reapeare when the workbook is closed.

Goodluck,

Wouter
 
L

Lady Layla

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


: 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
:
:
: ---
:
:
 
Top