View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Risky Dave Risky Dave is offline
external usenet poster
 
Posts: 161
Default Disabling Ribbon in '07

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