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
|
|||
|
|||
Disabling Standard Icons
I am running Office 2003 and I want to assign a error message to the SAVE
icon on the StandardToolbar to disable the standard save function to get the user to use another save button that I have set up on the spreadsheet. I know it can be done because I have it on a spreadsheet someone else set up but I cannot find where they set it up. It needs to be done in such a way that when I send the document (spreadsheet) to other Pc's it will still be setup. Any help would be most apprciated. |
#2
|
|||
|
|||
Disabling Standard Icons
Look in the macros on the example workbook.
Learning wrote: I am running Office 2003 and I want to assign a error message to the SAVE icon on the StandardToolbar to disable the standard save function to get the user to use another save button that I have set up on the spreadsheet. I know it can be done because I have it on a spreadsheet someone else set up but I cannot find where they set it up. It needs to be done in such a way that when I send the document (spreadsheet) to other Pc's it will still be setup. Any help would be most apprciated. |
#3
|
|||
|
|||
Disabling Standard Icons
thanks Bob and sorry to be dumb but where do I find the example workbook?
Thanks "Bob I" wrote: Look in the macros on the example workbook. Learning wrote: I am running Office 2003 and I want to assign a error message to the SAVE icon on the StandardToolbar to disable the standard save function to get the user to use another save button that I have set up on the spreadsheet. I know it can be done because I have it on a spreadsheet someone else set up but I cannot find where they set it up. It needs to be done in such a way that when I send the document (spreadsheet) to other Pc's it will still be setup. Any help would be most apprciated. . |
#4
|
|||
|
|||
Disabling Standard Icons
You said "I know it can be done because I have it on a spreadsheet
someone else set up but I cannot find where they set it up." That is the example workbook. Look in the Macros. Learning wrote: thanks Bob and sorry to be dumb but where do I find the example workbook? Thanks "Bob I" wrote: Look in the macros on the example workbook. Learning wrote: I am running Office 2003 and I want to assign a error message to the SAVE icon on the StandardToolbar to disable the standard save function to get the user to use another save button that I have set up on the spreadsheet. I know it can be done because I have it on a spreadsheet someone else set up but I cannot find where they set it up. It needs to be done in such a way that when I send the document (spreadsheet) to other Pc's it will still be setup. Any help would be most apprciated. . |
#5
|
|||
|
|||
Disabling Standard Icons
Thanks but that was the first place I looked and "I cannot find where they
set it up.". I am looking where all macros for the sheet are but is there some system area in the macro or some keywork I should be searching for. In the example workbook it prints a whole error message which I have looked for but cannot find. "Bob I" wrote: You said "I know it can be done because I have it on a spreadsheet someone else set up but I cannot find where they set it up." That is the example workbook. Look in the Macros. Learning wrote: thanks Bob and sorry to be dumb but where do I find the example workbook? Thanks "Bob I" wrote: Look in the macros on the example workbook. Learning wrote: I am running Office 2003 and I want to assign a error message to the SAVE icon on the StandardToolbar to disable the standard save function to get the user to use another save button that I have set up on the spreadsheet. I know it can be done because I have it on a spreadsheet someone else set up but I cannot find where they set it up. It needs to be done in such a way that when I send the document (spreadsheet) to other Pc's it will still be setup. Any help would be most apprciated. . . |
#6
|
|||
|
|||
Disabling Standard Icons
Press Alt+F11 and nose around in the VB editor.
Learning wrote: Thanks but that was the first place I looked and "I cannot find where they set it up.". I am looking where all macros for the sheet are but is there some system area in the macro or some keywork I should be searching for. In the example workbook it prints a whole error message which I have looked for but cannot find. "Bob I" wrote: You said "I know it can be done because I have it on a spreadsheet someone else set up but I cannot find where they set it up." That is the example workbook. Look in the Macros. Learning wrote: thanks Bob and sorry to be dumb but where do I find the example workbook? Thanks "Bob I" wrote: Look in the macros on the example workbook. Learning wrote: I am running Office 2003 and I want to assign a error message to the SAVE icon on the StandardToolbar to disable the standard save function to get the user to use another save button that I have set up on the spreadsheet. I know it can be done because I have it on a spreadsheet someone else set up but I cannot find where they set it up. It needs to be done in such a way that when I send the document (spreadsheet) to other Pc's it will still be setup. Any help would be most apprciated. . . |
#7
|
|||
|
|||
Disabling Standard Icons
Ahhh wonderful .. Found it .. thanks Very MUCH for all your help and patience.
Alison "Bob I" wrote: Press Alt+F11 and nose around in the VB editor. Learning wrote: Thanks but that was the first place I looked and "I cannot find where they set it up.". I am looking where all macros for the sheet are but is there some system area in the macro or some keywork I should be searching for. In the example workbook it prints a whole error message which I have looked for but cannot find. "Bob I" wrote: You said "I know it can be done because I have it on a spreadsheet someone else set up but I cannot find where they set it up." That is the example workbook. Look in the Macros. Learning wrote: thanks Bob and sorry to be dumb but where do I find the example workbook? Thanks "Bob I" wrote: Look in the macros on the example workbook. Learning wrote: I am running Office 2003 and I want to assign a error message to the SAVE icon on the StandardToolbar to disable the standard save function to get the user to use another save button that I have set up on the spreadsheet. I know it can be done because I have it on a spreadsheet someone else set up but I cannot find where they set it up. It needs to be done in such a way that when I send the document (spreadsheet) to other Pc's it will still be setup. Any help would be most apprciated. . . . |
#8
|
|||
|
|||
Disabling Standard Icons
You're welcome, have a great day!
Learning wrote: Ahhh wonderful .. Found it .. thanks Very MUCH for all your help and patience. Alison "Bob I" wrote: Press Alt+F11 and nose around in the VB editor. Learning wrote: Thanks but that was the first place I looked and "I cannot find where they set it up.". I am looking where all macros for the sheet are but is there some system area in the macro or some keywork I should be searching for. In the example workbook it prints a whole error message which I have looked for but cannot find. "Bob I" wrote: You said "I know it can be done because I have it on a spreadsheet someone else set up but I cannot find where they set it up." That is the example workbook. Look in the Macros. Learning wrote: thanks Bob and sorry to be dumb but where do I find the example workbook? Thanks "Bob I" wrote: Look in the macros on the example workbook. Learning wrote: I am running Office 2003 and I want to assign a error message to the SAVE icon on the StandardToolbar to disable the standard save function to get the user to use another save button that I have set up on the spreadsheet. I know it can be done because I have it on a spreadsheet someone else set up but I cannot find where they set it up. It needs to be done in such a way that when I send the document (spreadsheet) to other Pc's it will still be setup. Any help would be most apprciated. . . . |
Thread Tools | |
Display Modes | |
|
|