How to Disable Tab from Excel 2007

[Nitesh Khot]

Hi..,

I am looking code to disable Home, Insert , Data tab to be disabled when workbook open..

is there any code to to do this ..

Thanks in advance..

 

[Deepak]

Option Explicit

Private Sub Workbook_BeforeClose(Cancel As Boolean)
ActiveWindow.Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",true)"
End Sub

Private Sub Workbook_Open()
ActiveWindow.Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",False)"
End Sub

 

[Nitesh Khot]

Thanks Deepak....Work like robot.......