Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
auto load personal command bar
I loaded a special style format button. I have to manually merge from
personal to the sheet I am working in when I first use the button in a new workbook. Is there a way to get the personal command bar styles associated with my command button to copy to all new worksheets? My macros are always available that I have in my personal. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
auto load personal command bar
I provided some code in here that will produce a programmed toolbar... If
you search for "GB Toolbar" (minus the quotes) you should find at least one instance of a thread that has like 18 or more messages. Basically through the conversations of helping someone else, you should see the ability to do what you want... My code produces an entirely new toolbar, but... You could incorporate something similar to get just your one button. If you put the code that I provided in a module called toolbars then it will work as written, and you can go through and find the information you need to programmatically create the button you want... Ie. all of the bells and whistles that you probably have already done on your own. My code creates a commandbar that is free wheeling (i.e. is not docked at the top, bottom, or sides.) It can be docked by the user, or you could force it to be by changing the msoPosition portion. Give it a shot, there should be plenty of discussion there to help you out. :) Just might take a little bit to get through all of the messages. :) "jenn" wrote: I loaded a special style format button. I have to manually merge from personal to the sheet I am working in when I first use the button in a new workbook. Is there a way to get the personal command bar styles associated with my command button to copy to all new worksheets? My macros are always available that I have in my personal. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
i cannot get my excel personal macro workbook to load automaticall | Excel Discussion (Misc queries) | |||
cannot get my excel personal macro workbook to load automatically | Excel Discussion (Misc queries) | |||
personal.xls will not load | Excel Worksheet Functions | |||
Failure to load personal.xls | Setting up and Configuration of Excel | |||
Excel will not load personal.xls | Setting up and Configuration of Excel |