assigning macro to toolbar button

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

OK, so I've assigned a macro to a toolbar button but how do I set it so that
it doesn't open the workbook it was originally created in? Is there a way to
add it to the normal template or something?
 
If you put the macro in your personal.xls file in your xlstart folder, it
will always be loaded. Just be sure the botton's macro assignment points to
the correct module in personal.xls
 
where's the xlstart folder typically located?

Gary''s Student said:
If you put the macro in your personal.xls file in your xlstart folder, it
will always be loaded. Just be sure the botton's macro assignment points to
the correct module in personal.xls
Click to expand...
 
You must log in or register to reply here.

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

Similar Threads

customized toolbar issue 1
Assigning macro to toolbar - only works sometimes! 4
Macro Buttons 4
Create A Button and Assign A Macro To It 2
Macro code behind button 1
assign macro - toolbar 2
Sharing Macros 1
Invoking a Visual Basic macro from a Custom Toolbar Button 2

Back
Top