1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Disabling Standard Icons

Discussion in 'Microsoft Office' started by Learning, Feb 11, 2010.

  1. Learning

    Learning Flightless Bird

    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. Bob I

    Bob I Flightless Bird

    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. Learning

    Learning Flightless Bird

    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. Bob I

    Bob I Flightless Bird

    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. Learning

    Learning Flightless Bird

    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. Bob I

    Bob I Flightless Bird

    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. Learning

    Learning Flightless Bird

    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. Bob I

    Bob I Flightless Bird

    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.
    >>>>>>
    >>>>>>.
    >>>>>>
    >>>>
    >>>>.
    >>>>

    >>
    >>.
    >>
     

Share This Page