excel macro - maipulating toolbar using opening maro and closing macro

  • Thread starter Thread starter arunjoshi
  • Start date Start date
A

arunjoshi

i want a macro that automartically runs when the file is opened. thi
macro shiuld be able to keep a record of all the toolbars. it shoul
then remove all toolbars. when the file is closed, before gettin
closed, a macro should be inititaed, this macro should be able t
repoduce the toolbars as were there originally
 
Personally, I think doing something like that will make all your users hate
you. I know that if you did that to me and something crashed and I lost
some or all of my personalized commandbars, I would hunt you down and delete
all your add-ins and macros, and then reformat your hard disk with a
ball-peen hammer. ;-)

Design your app to have its own commandbar, by all means, but leave your
users' commandbars alone. If you need or want more control than that, then
write your application in VB or some other compilable language.

HTH,
Bernie
MS Excel MVP
 
Back
Top