Macro Close 2

[Ronbo]

Thank-you Ron de Bruin for you help on the first question
and for and all of the other help you have given me and
others. It is truly appreciated.

Your last answer works great, but leads to a lot more.

1. When I turn off tools it is global or fixed in excel
until I turn it back on. Is there a way (without upon
open/close)for excel to revert back to the defult
settings upon close?

2. Is there a way to turn off the menu bar completly?

3. If I send this spread sheet to others with (Upon
open/close) is there any way that it would permenantly
change there settings?

Again, thanks a lot for you help.

 

[Ron de Bruin]

Hi

1)

You must run this code in a Event.
Use the following events in the thisworkbook module

Private Sub Workbook_Activate()

End Sub

Private Sub Workbook_Deactivate()

End Sub

Check out the following link
http://support.microsoft.com/default.aspx?scid=kb;en-us;166755&Product=xlw97
XL97: WE1183: "Customizing Menu Bars, Menus, and Menu Items"


2)
Application.CommandBars(1).Enabled = False


3)
If the use Disable macro's it will not hide the menu bar or Item