Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 45
Default Reset Excel Defaults

I teach Excel and we go through a customize the environment
(Tools/Options/General-Username), Add-Ins, Customize toolbars and menus, etc.
So I recorded a macro to see what would stick and I only got the General
Options and Addins, not reset customized toolbars or menus; Any ideas how to
reset this stuff easily? TIA for any ideas!!!
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Reset Excel Defaults


I am sure you can't do this with a macro recorder here's the microsoft
site to hide and restore toolbars
http://support.microsoft.com/?kbid=213487

I saw J-Walk also has a code that will read what ever toolbars are
showing and store them onto a worksheet when the file is open and then
restore them again when the workbook is closed, it's in the "VBA
Programming for Dummies Book"


--
davesexcel


------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=543898

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
Excel Workbook Defaults WildWill Excel Discussion (Misc queries) 1 October 21st 09 02:09 PM
Changing Excel defaults David Schwartz Excel Discussion (Misc queries) 1 January 9th 09 06:59 PM
Excel page break defaults? Jed Excel Discussion (Misc queries) 3 October 11th 06 09:57 PM
Changing Excel defaults Tom Kreutz Excel Discussion (Misc queries) 2 March 2nd 06 02:25 PM
How to reset Excel 2000 toolbars to "factory defaults"? [email protected] Excel Discussion (Misc queries) 3 March 28th 05 10:39 PM


All times are GMT +1. The time now is 03:38 PM.

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

About Us

"It's about Microsoft Excel"