excel macro - maipulating toolbar using opening maro and closing macro

i want a macro that automartically runs when the file is opened. this
macro shiuld be able to keep a record of all the toolbars. it should
then remove all toolbars. when the file is closed, before getting
closed, a macro should be inititaed, this macro should be able to
repoduce the toolbars as were there originally.


---
Message posted from http://www.ExcelForum.com/

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

"arunjoshi " wrote in message
...
i want a macro that automartically runs when the file is opened. this
macro shiuld be able to keep a record of all the toolbars. it should
then remove all toolbars. when the file is closed, before getting
closed, a macro should be inititaed, this macro should be able to
repoduce the toolbars as were there originally.


---
Message posted from http://www.ExcelForum.com/