Disabling Ribbon in '07

[Risky Dave]

Hi,

I have a piece of code that disables the ribbon under Vista in Office '07:

Private Sub Workbook_Open()
Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",False)" '
disables user ribbon functionality
<do other stuff here>
end sub()

This works as intended but it also turns off the ribbon in any other
spreadsheets that are open at the same time. Is it possible to turn off the
ribbon only in my spreadsheet?

TIA

Dave

 

[Orion Cochrane]

Make a Workbook_Activate event that calls Workbook_Open and a
Workbook_Deactivate event that reverses your Workbook_Open event. This should
work.

 

[Risky Dave]

Perfect! My thanks

Make a Workbook_Activate event that calls Workbook_Open and a
Workbook_Deactivate event that reverses your Workbook_Open event. This should
work.

 

[Orion Cochrane]

No problem. I know this because when I manipulate the Status Bar, I want the
messages contained to only apply to the specific workbook. Glad to help!

 

[Ron de Bruin]

Hi Risky

You can also do it without code (with RibbonX)

See
http://www.rondebruin.nl/ribbon.htm

Try one of the dictator examples in section 2