I want to assign a macro (error message) to the SAVE icon on the Standard
Toolbar to disable that save function to get the user to use the save button
I have set up on the Sheet. I know it can be done because I have it on a
spreadsheet someone elsse set up but I cannot find where they set it up.

THANKS for any help.

In EXCEL 2007 take the following actions:-

Office Button (top left hand corner).

Excel Options

Customize

In:-

Choose commands from:

- select Macros

Highlight the Macro you wish to attach to the Save button

Add

Your Macro should now be added to the bottom of the list on the right hand
side. Click it to highlight it.

Select:-

Modify . . .

- button towards lower right hand side.

Choose the, €œSave€� icon and hit OK. Your Macro now has that icon assigned to
it.

Click on OK.

Your new button will now appear on the far right hand side of the Quick
Access Tooolbar (which itself is found towards the top left hand corner of
your EXCEL 2007 window).

If my comments have helped please hit Yes.

Thanks.



"HomeTaught" wrote:

I want to assign a macro (error message) to the SAVE icon on the Standard
Toolbar to disable that save function to get the user to use the save button
I have set up on the Sheet. I know it can be done because I have it on a
spreadsheet someone elsse set up but I cannot find where they set it up.

THANKS for any help.

Thanks I can see how this would work but will it have the icon only for the
one specific spreadsheet or for all spreadsheets for that computer. I want it
to be assigned with spreadsheet so that I do not have to do it on all
computers. Also, on thinking about it is it easier to do if I just give an
error message when they click the "save icon" rather than assigning it to run
a macro?
Thanks

"trip_to_tokyo" wrote:


In EXCEL 2007 take the following actions:-

Office Button (top left hand corner).

Excel Options

Customize

In:-

Choose commands from:

- select Macros

Highlight the Macro you wish to attach to the Save button

Add

Your Macro should now be added to the bottom of the list on the right hand
side. Click it to highlight it.

Select:-

Modify . . .

- button towards lower right hand side.

Choose the, €œSave€� icon and hit OK. Your Macro now has that icon assigned to
it.

Click on OK.

Your new button will now appear on the far right hand side of the Quick
Access Tooolbar (which itself is found towards the top left hand corner of
your EXCEL 2007 window).

If my comments have helped please hit Yes.

Thanks.



"HomeTaught" wrote:

I want to assign a macro (error message) to the SAVE icon on the Standard
Toolbar to disable that save function to get the user to use the save button
I have set up on the Sheet. I know it can be done because I have it on a
spreadsheet someone elsse set up but I cannot find where they set it up.

THANKS for any help.

I still need help .. Trip to Tokyo gave me one way but this is not good as I
send the spreadsheet out to other PC's and this change only makes it for that
PC.

does anyone else have any ideas PLEASE.

"HomeTaught" wrote:

I want to assign a macro (error message) to the SAVE icon on the Standard
Toolbar to disable that save function to get the user to use the save button
I have set up on the Sheet. I know it can be done because I have it on a
spreadsheet someone elsse set up but I cannot find where they set it up.

THANKS for any help.