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 ;)

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

Try

Application.CommandBars.FindControl(ID:=30029).Vis ible = False


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




"I Believe" wrote in message
...
Hi everyone,
I was wondering how I might hide the "Protection" option from
the "Tools"
menu?

TIA! have a nice day ;)

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

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

Application.CommandBars.FindControl(ID:=30029).Ena ble = 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).Vis ible = False


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




"I Believe" wrote in message
...
Hi everyone,
I was wondering how I might hide the "Protection" option from
the "Tools"
menu?

TIA! have a nice day ;)