Re: Macro referencing wrong form

Hi JS,

Thanks heaps for getting back to me. 

After reading a bit more up on this (prior to receiving your msg) I
discovered that, as you say, the only way to avoid this is to create
the button and toolbar in code.

I can do this with the references I have, so whilst I appreciate your
offer, I won't bother you with it any further.

Thanks again !

VanIkyn

"JS" <[EMAIL PROTECTED]> wrote in message news:<[EMAIL PROTECTED]>...
> Hi,
> 
> This happens when you create a toolbar button and attach a macro to it.  As
> soon as you save the worksheet and save it as a different name it looks for
> the original spreadsheet.  The best way to solve it is to create the toolbar
> button to run the macro using code when your macro loads.  I can e-mail an
> example of this if you like?
> 
> JS