Menu Item Deleted

[Guest]

In one excel file, in the ThisWorkbook object, in the Private Sub
Workbook_Open() event, I entered the this line of code:
Application.CommandBars(1).Name("Format").Delete
The intent was to disable Format>Sheets>unhide to the users in this
particular file.
Format has gone away in all instances of Excel and reinstalls do not cure
the problem. I am at a loss. Can anyone help?

 

[Ron de Bruin]

Hi Caddy

I think you used
Application.CommandBars(1).Controls("Format").Delete

You can reset it like this
Application.CommandBars(1).Reset

For more information see
http://www.rondebruin.com/menuid.htm

 

[Bob Phillips]

BTW, the code you want is

Application.CommandBars(1).Controls("Format").controls("Sheet").controls("Un
hide...").enabled=false


--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Ron de Bruin]

Hi Caddy

If your workbook will also be used in non US Excel versions use the ID numbers
of the control(see my site).
If not use Bob's example

 

[Bob Phillips]

Ron,

I keep forgetting that. Thanks

Bob

Hi Caddy

If your workbook will also be used in non US Excel versions use the ID numbers
of the control(see my site).
If not use Bob's example