ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   saving toolbar (https://www.excelbanter.com/excel-discussion-misc-queries/2568-saving-toolbar.html)

choice

saving toolbar
 
i have created a toolbar menu in excel, saved the excel file.
however when i close and reopen excel it reverts back to the previous menu
toolbar.
i have a auto_open code, but that doesnt do anything to the toolbar.
any help would be appreciated.

thanks in advance


galimi

Please post the code...

"choice" wrote:

i have created a toolbar menu in excel, saved the excel file.
however when i close and reopen excel it reverts back to the previous menu
toolbar.
i have a auto_open code, but that doesnt do anything to the toolbar.
any help would be appreciated.

thanks in advance


Jim Rech

have created a toolbar menu in excel, saved the excel file. however when
i close and reopen excel it reverts back to the previous menu


After you make your changes be sure to re-attach the toolbar to your
workbook before you save it. Also, you should have Auto_Close code that
deletes the toolbar.

--
Jim Rech
Excel MVP
"choice" wrote in message
...
|i have created a toolbar menu in excel, saved the excel file.
| however when i close and reopen excel it reverts back to the previous menu
| toolbar.
| i have a auto_open code, but that doesnt do anything to the toolbar.
| any help would be appreciated.
|
| thanks in advance
|




All times are GMT +1. The time now is 08:47 PM.

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