ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   CANT SAVE TOOLBAR CHANGES EXCEL 2003) (https://www.excelbanter.com/excel-discussion-misc-queries/54315-cant-save-toolbar-changes-excel-2003-a.html)

Paul628

CANT SAVE TOOLBAR CHANGES EXCEL 2003)
 
CANT SAVE EXCEL 2003 TOOLBARS

I have added a new custom toolbar to a new Excel 2003 worksheet and saved
the worksheet. But when I re-open the saved worksheet, the new toolbar is
gone. And, if I click on VIEW | TOOLBARS it is not there either.

Also, when I open ANY old / existing document and change any toolbar, the
next time I open the document, the changes are gone.

For example, if I assign a different macro to one of the custom buttons on
an existing toolbar, when I re-open the document the new assignment is lost
and it always goes back to the old / original assignment.

I have been creating and modifying toolbars and assigning macros to custom
toolbar buttons for years. I am an experienced programmer. None of my other
copies of Excel 2003 (on several other computers) give me this type of
problems. I am extremely frustrated by this.

Could there be a hidden system setting that might be preventing this
installation of Excel from saving the changes that I make to toolbars?

Please help.

PS: In addition to replying to this bulletin board, it would be most
helpful if you would also send a copy directly to my email address (paul628
at concentric dot net) because I might not be able to re-find this bulletin
board.

Email address: Paul628 at concentric dot net

PS: OK to call me at home on 908-630-0406

--
Paul6238 (Email paul628 at concentric dot net)

Bob Umlas

CANT SAVE TOOLBAR CHANGES EXCEL 2003)
 
saving the workbook does NOT sate the changes to toolbars. You MUST first fo
to Customize, click the Attach toolbars buttons, click the tool bar in the
"toolbars in workbook" listbox then click Delete, THEN click the same one in
the "custom toolbars" lilstbhox and click the copy button. Click OK all the
way out, and NOW when ytou save the workbook the new toolbar is saved.
Bob Umlas
Excel MVP

"Paul628" <paul628 at concentric dot net wrote in message
...
CAN'T SAVE EXCEL 2003 TOOLBARS

I have added a new custom toolbar to a new Excel 2003 worksheet and saved
the worksheet. But when I re-open the saved worksheet, the new toolbar is
gone. And, if I click on VIEW | TOOLBARS it is not there either.

Also, when I open ANY old / existing document and change any toolbar, the
next time I open the document, the changes are gone.

For example, if I assign a different macro to one of the custom buttons on
an existing toolbar, when I re-open the document the new assignment is

lost
and it always goes back to the old / original assignment.

I have been creating and modifying toolbars and assigning macros to custom
toolbar buttons for years. I am an experienced programmer. None of my

other
copies of Excel 2003 (on several other computers) give me this type of
problems. I am extremely frustrated by this.

Could there be a hidden system setting that might be preventing this
installation of Excel from saving the changes that I make to toolbars?

Please help.

PS: In addition to replying to this bulletin board, it would be most
helpful if you would also send a copy directly to my email address

(paul628
at concentric dot net) because I might not be able to re-find this

bulletin
board.

Email address: Paul628 at concentric dot net

PS: OK to call me at home on 908-630-0406

--
Paul6238 (Email paul628 at concentric dot net)




Paul628

CANT SAVE TOOLBAR CHANGES EXCEL 2003)
 
Bob: My newly created toolbar should come up each time I launch / open Excel
even if it (the new toolbar) was created while there were no files open.

A new tool bar that was created when no files were open should not need to
be €śattached€ť to any particular file. It works OK that way on all my other
computers that have Excel2003. Only one PC is giving me that problem.

On my newest computer, when I re-open Excel, the new toolbar is gone.

--
Paul6238 (Email paul628 at concentric dot net)


"Bob Umlas" wrote:

saving the workbook does NOT sate the changes to toolbars. You MUST first fo
to Customize, click the Attach toolbars buttons, click the tool bar in the
"toolbars in workbook" listbox then click Delete, THEN click the same one in
the "custom toolbars" lilstbhox and click the copy button. Click OK all the
way out, and NOW when ytou save the workbook the new toolbar is saved.
Bob Umlas
Excel MVP

"Paul628" <paul628 at concentric dot net wrote in message
...
CAN'T SAVE EXCEL 2003 TOOLBARS

I have added a new custom toolbar to a new Excel 2003 worksheet and saved
the worksheet. But when I re-open the saved worksheet, the new toolbar is
gone. And, if I click on VIEW | TOOLBARS it is not there either.

Also, when I open ANY old / existing document and change any toolbar, the
next time I open the document, the changes are gone.

For example, if I assign a different macro to one of the custom buttons on
an existing toolbar, when I re-open the document the new assignment is

lost
and it always goes back to the old / original assignment.

I have been creating and modifying toolbars and assigning macros to custom
toolbar buttons for years. I am an experienced programmer. None of my

other
copies of Excel 2003 (on several other computers) give me this type of
problems. I am extremely frustrated by this.

Could there be a hidden system setting that might be preventing this
installation of Excel from saving the changes that I make to toolbars?

Please help.

PS: In addition to replying to this bulletin board, it would be most
helpful if you would also send a copy directly to my email address

(paul628
at concentric dot net) because I might not be able to re-find this

bulletin
board.

Email address: Paul628 at concentric dot net

PS: OK to call me at home on 908-630-0406

--
Paul6238 (Email paul628 at concentric dot net)






All times are GMT +1. The time now is 11:04 PM.

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