personal panel

[WayneF]

Hi all i am a bit of a newbie and trying to something a bit advanced but
here goes...

I have made an excel workbook which has some macro's in it. Then I
asigned these macros to buttons on a tool bar.
Everything works tic-a-dee-boo !! (great)

Now the problem ....

I need to transfer this document between emplyees and if the name of the
document changes then the panel does not work. I need to constantly delete
the panel and re-open the document.
I guess when i click on the button it tries to find the path to the
original document.
This problem occurs if you change the file name, or move the location.
Is there a fix/work around for my problem ? Can i force excel to reload
the tool panel that is in the document each time that it is opened ?

I am working with excel 2000 through to 2003 so any soloution needs to
work in this range.

Thanks for your help,

Wayne

[Dave Peterson]

If you create the toolbar when the workbook opens (and delete it when the
workbook closes), it'll be easier to manage.

If I want to add options to the menubar, I use a variation of John Walkenbach's
menumaker:
http://j-walk.com/ss/excel/tips/tip53.htm

If I want to add a toolbar of my own, here's how I do it:
http://groups.google.co.uk/groups?th...5B41%40msn.com

WayneF wrote:
>
> Hi all i am a bit of a newbie and trying to something a bit advanced but
> here goes...
>
> I have made an excel workbook which has some macro's in it. Then I
> asigned these macros to buttons on a tool bar.
> Everything works tic-a-dee-boo !! (great)
>
> Now the problem ....
>
> I need to transfer this document between emplyees and if the name of the
> document changes then the panel does not work. I need to constantly delete
> the panel and re-open the document.
> I guess when i click on the button it tries to find the path to the
> original document.
> This problem occurs if you change the file name, or move the location.
> Is there a fix/work around for my problem ? Can i force excel to reload
> the tool panel that is in the document each time that it is opened ?
>
> I am working with excel 2000 through to 2003 so any soloution needs to
> work in this range.
>
> Thanks for your help,
>
> Wayne

--

Dave Peterson

[WayneF]

Thanks a lot for that I got everything working sweet


"Dave Peterson" <[email protected]> wrote in message
news:[email protected]...
> If you create the toolbar when the workbook opens (and delete it when the
> workbook closes), it'll be easier to manage.
>
> If I want to add options to the menubar, I use a variation of John
> Walkenbach's
> menumaker:
> http://j-walk.com/ss/excel/tips/tip53.htm
>
> If I want to add a toolbar of my own, here's how I do it:
> http://groups.google.co.uk/groups?th...5B41%40msn.com
>
> WayneF wrote:
>>
>> Hi all i am a bit of a newbie and trying to something a bit advanced
>> but
>> here goes...
>>
>> I have made an excel workbook which has some macro's in it. Then I
>> asigned these macros to buttons on a tool bar.
>> Everything works tic-a-dee-boo !! (great)
>>
>> Now the problem ....
>>
>> I need to transfer this document between emplyees and if the name of
>> the
>> document changes then the panel does not work. I need to constantly
>> delete
>> the panel and re-open the document.
>> I guess when i click on the button it tries to find the path to the
>> original document.
>> This problem occurs if you change the file name, or move the
>> location.
>> Is there a fix/work around for my problem ? Can i force excel to
>> reload
>> the tool panel that is in the document each time that it is opened ?
>>
>> I am working with excel 2000 through to 2003 so any soloution needs
>> to
>> work in this range.
>>
>> Thanks for your help,
>>
>> Wayne
>
> --
>
> Dave Peterson