If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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/ |
#2
|
|||
|
|||
re How to disable or remove Save button.
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/ . |
#3
|
|||
|
|||
How to disable or remove Save button.
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... |
#4
|
|||
|
|||
How to disable or remove Save button.
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/ : |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Hide or Remove close button (x in top right hand corner) | ed | General Discussion | 2 | July 9th, 2004 12:05 AM |
Disabling Save Button | Andrew | General Discussion | 1 | June 24th, 2004 02:53 PM |
Close Button (Newbie) | Metastockuser | Using Forms | 2 | June 14th, 2004 08:16 AM |
office 2000 remove tools | bud | Setup, Installing & Configuration | 1 | May 27th, 2004 10:40 AM |