Disabling Standard Icons

[Learning]

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.

 

[Bob I]

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.

 

[Learning]

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.

>

> .

>

 

[Bob I]

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.

>>

>>.

>>

 

[Learning]

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.

> >>

> >>.

> >>

>

> .

>

 

[Bob I]

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.

>>>>

>>>>.

>>>>

>>

>>.

>>

 

[Learning]

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.

> >>>>

> >>>>.

> >>>>

> >>

> >>.

> >>

>

> .

>

 

[Bob I]

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.

>>>>>>

>>>>>>.

>>>>>>

>>>>

>>>>.

>>>>

>>

>>.

>>