Home |
Search |
Today's Posts |
#1
|
|||
|
|||
assigning macro to toolbar button
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? |
#2
|
|||
|
|||
assigning macro to toolbar button
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 -- Gary's Student "tjb" wrote: 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? |
#3
|
|||
|
|||
assigning macro to toolbar button
where's the xlstart folder typically located?
"Gary''s Student" wrote: 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 -- Gary's Student "tjb" wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to create a command button, then assign macro to it in excel | Excel Discussion (Misc queries) | |||
Assign a macro to Command Button Object | Excel Discussion (Misc queries) | |||
Macro Button | Excel Discussion (Misc queries) | |||
Change caption on a macro button | Excel Worksheet Functions | |||
Copying a workbook with custom toolbar assigned to a macro | Excel Discussion (Misc queries) |