Disable Worksheet Tab Menu
 

Hi

The menu when you right click on the Arrows ?
If not use 34 for the right click on a sheet tab

Copy this in the Thisworkbook module


Private Sub Workbook_Activate()
Application.CommandBars(27).Enabled = False
End Sub

Private Sub Workbook_Deactivate()
Application.CommandBars(27).Enabled = True
End Sub



--
Regards Ron de Bruin
http://www.rondebruin.nl


"cjsmile2106 " wrote in message ...
Hello Everyone,

Hope someone can help me out. I'm trying to find a code out there
that will disable the Worksheet tab menu. Also to have it only
disabled when the workbook is open and clear itself when the workbook
closes. I guess like a Workbook_Open/Workbook_Close function. Any
help out there would be great.

Thanks,
David


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

Disable Worksheet Tab Menu
 

Oops, you want to hide it I think

Hide it in ToolsOptions
It will be saved with the file this setting

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Ron de Bruin" wrote in message ...
Hi

The menu when you right click on the Arrows ?
If not use 34 for the right click on a sheet tab

Copy this in the Thisworkbook module


Private Sub Workbook_Activate()
Application.CommandBars(27).Enabled = False
End Sub

Private Sub Workbook_Deactivate()
Application.CommandBars(27).Enabled = True
End Sub



--
Regards Ron de Bruin
http://www.rondebruin.nl


"cjsmile2106 " wrote in message ...
Hello Everyone,

Hope someone can help me out. I'm trying to find a code out there
that will disable the Worksheet tab menu. Also to have it only
disabled when the workbook is open and clear itself when the workbook
closes. I guess like a Workbook_Open/Workbook_Close function. Any
help out there would be great.

Thanks,
David


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