Joined: 22 Apr 2002
Forgive me if this has been covered, but I couldn't find it referenced anywhere, and the problem is making me a little crazy.
Ok, I want to hide toolbars during the Auto_Open sub, which is easy enough to do. I want to put them back during the Auto_Close sub, which again, is easy enough to do.
My problem is this: suppose the user has a toolbar already hidden (this is how he or she wants Excel set up) before my program runs. Now, if I try to hide something that is already hidden (via my Auto_Open sub), there is no problem, the VBA routine chugs along happily. The trouble comes at the Auto_Close sub; I may unhide something that should be left hidden (at least as far as this particular user is concerned).
Thus, I want to leave Excel set up exactly as it was before the user started my program.
Any thoughts on how to best accomplish this? Please let me know if I have done a poor job describing my dilemma and I will try to explain differently.
Thanks in advance for your suggestions.