Reset Excel Defaults

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

headly - 20 May 2006 01:40 GMT

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!!!

Reply to this Message

davesexcel - 20 May 2006 13:12 GMT

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"

Signature

davesexcel

Reply to this Message