• Welcome to Tux Reports: Where Penguins Fly. We hope you find the topics varied, interesting, and worthy of your time. Please become a member and join in the discussions.

Disabling Standard Icons

L

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

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

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

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

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

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

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

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.
>>>>>>
>>>>>>.
>>>>>>
>>>>
>>>>.
>>>>
>>
>>.
>>
 
You must log in or register to reply here.
Top