ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Custom Command Bars (https://www.excelbanter.com/excel-discussion-misc-queries/181765-custom-command-bars.html)

barrowhill

Custom Command Bars
 
I've created custom command bars in a 3 workbboks. I wish to retain these
workbooks and command bar but make copies of them for work sheet
alterations. Structure and format will be the same so command bars/Buttons
can be retained with only changes to names etc used in the macro's .

Obviously I can make copies of Worksheets under slightly different names but
is it possible to recreate existing custom command bars under different
names or create new command bar but copy buttons etc across ??

barrowhill

Custom Command Bars
 
Issues resolved. have accomplished what I wanted to achieve with a bit more
thought.

"barrowhill" wrote:

I've created custom command bars in a 3 workbboks. I wish to retain these
workbooks and command bar but make copies of them for work sheet
alterations. Structure and format will be the same so command bars/Buttons
can be retained with only changes to names etc used in the macro's .

Obviously I can make copies of Worksheets under slightly different names but
is it possible to recreate existing custom command bars under different
names or create new command bar but copy buttons etc across ??



All times are GMT +1. The time now is 01:15 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com