Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
kydan47
 
Posts: n/a
Default Preventing toolbar changes when opening someone else's spreadsheet

I receive spreadsheets from co-workers that use a different toolbar
arrangement (review toolbar, etc), and every time I open their spreadsheet,
close or save the sheet, and later reopen Excel, my template or spreadsheet
has adopted their layout.

Is there any way to keep or return to my toolbar configuration without
manually resetting (closing, and opening different toolbars)?

Any help greatly appreciated!
--
Thanks!
kydan47
  #2   Report Post  
Alan
 
Posts: n/a
Default

That reviewing toolbar is a curse. It is of absolutely no use to me, perhaps
it is to someone else.
The only way I know of to retain the toolbar settings is with code, but that
involves using code in every workbook which is almost as much as of a pain
as resetting the toolbars by hand. If anyone knows a way to do this I would
be gratefull as well as you!
Regards,
Alan.
"kydan47" wrote in message
...
I receive spreadsheets from co-workers that use a different toolbar
arrangement (review toolbar, etc), and every time I open their
spreadsheet,
close or save the sheet, and later reopen Excel, my template or
spreadsheet
has adopted their layout.

Is there any way to keep or return to my toolbar configuration without
manually resetting (closing, and opening different toolbars)?

Any help greatly appreciated!
--
Thanks!
kydan47



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 to stop Reviewing toolbar from opening when I open a file WFLD Excel Discussion (Misc queries) 2 March 24th 05 12:43 AM
custom toolbar w/ macro Darien Excel Discussion (Misc queries) 3 February 2nd 05 09:16 PM
"Drawing" Toolbar is inactive Deauxx Excel Discussion (Misc queries) 1 December 8th 04 03:03 PM
Slow opening files - possible cause and solutoin Bob Flanagan Excel Discussion (Misc queries) 0 November 29th 04 10:04 PM
How do I stop the Reviewing toolbar from showing up in Excel? RickKel Excel Discussion (Misc queries) 2 November 26th 04 05:37 PM


All times are GMT +1. The time now is 04:31 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"