Menu Item Deleted
 

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 FormatSheetsunhide 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?

Menu Item Deleted
 

Hi Caddy

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

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

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


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



"Caddy Shack" wrote in message ...
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 FormatSheetsunhide 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?

Menu Item Deleted
 

BTW, the code you want is

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


--

HTH

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


"Ron de Bruin" wrote in message
...
Hi Caddy

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

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

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


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



"Caddy Shack" wrote in message
...
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 FormatSheetsunhide 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?

Menu Item Deleted
 

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

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



"Bob Phillips" wrote in message ...
BTW, the code you want is

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


--

HTH

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


"Ron de Bruin" wrote in message
...
Hi Caddy

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

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

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


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



"Caddy Shack" wrote in message
...
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 FormatSheetsunhide 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?

Menu Item Deleted
 

Ron,

I keep forgetting that. Thanks

Bob


"Ron de Bruin" wrote in message
...
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

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



"Bob Phillips" wrote in message
...
BTW, the code you want is


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


--

HTH

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


"Ron de Bruin" wrote in message
...
Hi Caddy

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

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

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


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



"Caddy Shack" wrote in message
...
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 FormatSheetsunhide 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?