Stop users from accessing "Protection" option from "Tools" menu

Hi everyone,
I was wondering how I might hide the "Protection" option from the "Tools"
menu?

TIA! have a nice day

Try

Application.CommandBars.FindControl(ID:=30029).Visible = False


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"I Believe" <[email protected]> wrote in message
news:[email protected]...
> Hi everyone,
> I was wondering how I might hide the "Protection" option from
> the "Tools"
> menu?
>
> TIA! have a nice day

Thanks Chip, exactly what I wanted, but I've modified to:

Application.CommandBars.FindControl(ID:=30029).Enable = False

because I think this will be more transparant to my users about whats going
on.

Cheers.

"Chip Pearson" wrote:

> Try
>
> Application.CommandBars.FindControl(ID:=30029).Visible = False
>
>
> --
> Cordially,
> Chip Pearson
> Microsoft MVP - Excel
> Pearson Software Consulting, LLC
> www.cpearson.com
>
>
>
>
> "I Believe" <[email protected]> wrote in message
> news:[email protected]...
> > Hi everyone,
> > I was wondering how I might hide the "Protection" option from
> > the "Tools"
> > menu?
> >
> > TIA! have a nice day
>
>
>