![]() |
hide custom toolbar from Toolbar list
Hi All,
I am wondering if there is a way (via code or something) for me to hide my custom toolbar from the Toolbar list .... so when anyone right click on the toolbar and the list of tools display, my custom one will not be an option on there. Also, is there a code that once I close my excel workbook that has the custom toolbar, the toolbar will not display when I open a new workbook? thanks for the help! -- Learning |
hide custom toolbar from Toolbar list
Somebody please correct me if I'm wrong, but your custom toolbar is exclusive
to you in the first place. You create it in your own Excel environment, not in any particular Excel file. -- Time is just the thing that keeps everything from happening all at once "tracktraining" wrote: Hi All, I am wondering if there is a way (via code or something) for me to hide my custom toolbar from the Toolbar list .... so when anyone right click on the toolbar and the list of tools display, my custom one will not be an option on there. Also, is there a code that once I close my excel workbook that has the custom toolbar, the toolbar will not display when I open a new workbook? thanks for the help! -- Learning |
hide custom toolbar from Toolbar list
AFAIK it is not possible to hide a custom toolbar from the Toolbar list.
Why not create and delete your toolbar as/when needed, eg in workbook activate/deactivate events. Regards, Peter T "tracktraining" wrote in message ... Hi All, I am wondering if there is a way (via code or something) for me to hide my custom toolbar from the Toolbar list .... so when anyone right click on the toolbar and the list of tools display, my custom one will not be an option on there. Also, is there a code that once I close my excel workbook that has the custom toolbar, the toolbar will not display when I open a new workbook? thanks for the help! -- Learning |
hide custom toolbar from Toolbar list
thanks!
-- Learning "Peter T" wrote: AFAIK it is not possible to hide a custom toolbar from the Toolbar list. Why not create and delete your toolbar as/when needed, eg in workbook activate/deactivate events. Regards, Peter T "tracktraining" wrote in message ... Hi All, I am wondering if there is a way (via code or something) for me to hide my custom toolbar from the Toolbar list .... so when anyone right click on the toolbar and the list of tools display, my custom one will not be an option on there. Also, is there a code that once I close my excel workbook that has the custom toolbar, the toolbar will not display when I open a new workbook? thanks for the help! -- Learning |
All times are GMT +1. The time now is 12:26 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com