Custom Toolbar Macro - Path Name

K

Karin

I've created a custom toolbar with macros attached. I figured out how to
copy the personal.xls and excel.xlb files to a co-workers computer. The
problem is that the macros have a path that leads to a directory with my name
on it. Where can I find the location of the path attached to the
macro/toolbar and change it to her path?
 
P

pa_broon74

Hey.

I wouldn't mind knowing about this too, I did the same as you. Three
buttons with three corresponding macros, all they're doing on the
other computers is trying to open the spreadsheet containing the
macros and since it is already contained within the XLstart folder its
already open...

As to your problem, open up the VB editor (Tools - Macros [highlight
the macro you wish to change] - Edit) and find the line in the VB
script that tells it where the external file is and change it to the
new file path on the other user's PC. As long as you keep the same
syntax it should work ok.

Remember to keep a back up of the macro incase you make a mistake, (If
you do make a mistake the editor highlights the line of script in
yellow...)

Hope this is helpful, if any one can tell me why my macros aren't
running properly it would certainly save a PC being lobbed out off a
window :)

Cheers.
 
K

Karin

Dave, I want the toolbar to always be available...and I'm no programmer.
The macros were auto recorded. I know how to go into VB, to copy and paste
macros, to import/export modules, but to create code as you suggest is
probably beyond me. That said, I'll take a look at your links and see what I
learn.
 
K

Karin

I've been in the VB code of the macros, but there is no path called out
anywhere that I can see.

To get the toolbar macros to work, I had to set the buttons up again
(because of the path issue).
 
K

Karin

Dave, that toolbar link makes things much more complicated, it seems to me,
than necessary. I just right click in the toolbar area, choose customize and
off I go. I then have a toolbar I can click on or off whenever I want
without writing code.
 
D

Dave Peterson

It may seem that creating the toolbar is more complex--until you have to
reassign all the icons to a different location.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top