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/[email protected]

 

[WayneF]

Thanks a lot for that I got everything working sweet