Sheet Tab options

J

Jignesh

Hi,

I am able to disable most of the options for sheet tabs
(right click menu on a sheet tab) but I cant remove the
View Code.. option - is there anyway? Also, if a sheet is
protected, can a user use the View Code option to modify
any of the data?

Thanks,

Jignesh.
 
B

Bob Phillips

This worked for me

Application.CommandBars("Ply").Controls("View Code").Enabled = False
 
Top