CommandBars(1).Reset

--

Vasant

"Simon Lloyd " wrote in message
...
Hi, I want to be able to reset the worksheet menu bar on auto close so
that it has its default settings, i already have an autoclose macro
which turns command bars back on and calculation etc.

Does anyone have a one liner i can insert to make this happen??

Thanks,

Simon


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