Manually assigning Macros to Buttons w/o File Dependence

  • Thread starter Thread starter TMAC
  • Start date Start date
T

TMAC

Same problem here. Been trying to figure this one out.
One suggestion is to build the toolbars dynamically when
the sheet opens by using the commandbars vbe function.

Im stumped as well. If i can find where the code is
stored for the custom toolbars I have made, I should be
able to cut and paste..

tim
-----Original Message-----
OK, another dumb one...I would like to assign a macro to a toolbar button in
a way which points to a macro of that name in the current workbook, without
having to write code to do this.

Right now, when I assign the macro manually, then save the spreadsheet under
a different name, Excel adds the originating
Click to expand...
spreadsheet's name to the macro
 
Right now, I think I will be putting the code into an add-in sheet. That way,
at least the static sheet name will be valid if the add-in is installed.
 
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

Unable to assign macros to a new button in the current worksheet 1
Assign Macro to Ribbon Button 6
assigning macro 2
assign macro - toolbar 2
Custom Toolbar - Buttons, Macro Assignment. 4
Assign macro 2
toolbars - button 2
Assigning macro buttons to macro code in another file 2

Back
Top