View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
dgold82 dgold82 is offline
external usenet poster
 
Posts: 99
Default Toolbars & command disabled

I found the following code that works great for me in that it disables right
click and all toolbars for the workbook on startup. Is there any way to
enable only certain right click functions. I have radio buttons that a user
will click on and I would like to keep "clear contents" available only.

Sub Commands()
Dim oCB As CommandBar
For Each oCB In Application.CommandBars
oCB.Enabled = False

Next oCB
End Sub