Lock sheet tabs option in a specific workbook

I want to Lock sheet tabs option in a specific workbook / worksheet & not for
all workbooks.

Have you try my answer in your other thread

You can disable Options in the Tools menu

Application.CommandBars("Worksheet Menu Bar").FindControl _
(ID:=522, Recursive:=True).Enabled = False

See also
http://www.rondebruin.nl/menuid.htm


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



"Tarique" <[email protected]> wrote in message news:[email protected]...
>I want to Lock sheet tabs option in a specific workbook / worksheet & not for
> all workbooks.

Well Ron thanks for answer but the problem is that this code lock the
permanently option command for all others workbook also. I want to lock the
options / Sheet tabs for a single worksheet but not for all.

"Ron de Bruin" wrote:

> Have you try my answer in your other thread
>
> You can disable Options in the Tools menu
>
> Application.CommandBars("Worksheet Menu Bar").FindControl _
> (ID:=522, Recursive:=True).Enabled = False
>
> See also
> http://www.rondebruin.nl/menuid.htm
>
>
> --
> Regards Ron de Bruin
> http://www.rondebruin.nl
>
>
>
> "Tarique" <[email protected]> wrote in message news:[email protected]...
> >I want to Lock sheet tabs option in a specific workbook / worksheet & not for
> > all workbooks.
>
>
>

See the link I posted
http://www.rondebruin.nl/menuid.htm

You can find a example that use the activate and deactivate event
See number 3 (information)

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



"Tarique" <[email protected]> wrote in message news:[email protected]...
> Well Ron thanks for answer but the problem is that this code lock the
> permanently option command for all others workbook also. I want to lock the
> options / Sheet tabs for a single worksheet but not for all.
>
> "Ron de Bruin" wrote:
>
>> Have you try my answer in your other thread
>>
>> You can disable Options in the Tools menu
>>
>> Application.CommandBars("Worksheet Menu Bar").FindControl _
>> (ID:=522, Recursive:=True).Enabled = False
>>
>> See also
>> http://www.rondebruin.nl/menuid.htm
>>
>>
>> --
>> Regards Ron de Bruin
>> http://www.rondebruin.nl
>>
>>
>>
>> "Tarique" <[email protected]> wrote in message news:[email protected]...
>> >I want to Lock sheet tabs option in a specific workbook / worksheet & not for
>> > all workbooks.
>>
>>
>>