Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Paul628
 
Posts: n/a
Default 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)
  #2   Report Post  
Bob Umlas
 
Posts: n/a
Default 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)



  #3   Report Post  
Paul628
 
Posts: n/a
Default 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)




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I open a Quattro Pro 7.0 file in Excel 2003 cpatrick83 Excel Discussion (Misc queries) 0 August 22nd 05 09:41 PM
Excel 2003: File->Close without saving changes (save menu does no. Wai-Yee Excel Discussion (Misc queries) 5 July 25th 05 11:49 PM
"Group" function very slow with Excel 2003 :( ... While very quick with Excel2000 :O) Alain79 Excel Discussion (Misc queries) 4 June 14th 05 07:34 AM
Save prompt for Excel 2003 Adrastos Setting up and Configuration of Excel 1 February 6th 05 07:54 PM
Save & Save As features in file menu of Excel Blue Excel Discussion (Misc queries) 9 December 27th 04 08:49 PM


All times are GMT +1. The time now is 01:46 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"