Menu Item Deleted

[Caddy Shack]

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


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



"Caddy Shack" <[email protected]> wrote in message news:[email protected]...
> 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?
>

[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" <[email protected]> wrote in message
news:[email protected]...
> 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
>
>
> --
> Regards Ron de Bruin
> http://www.rondebruin.nl
>
>
>
> "Caddy Shack" <[email protected]> wrote in message
news:[email protected]...
> > 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

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" <[email protected]> wrote in message news:[email protected]...
> 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" <[email protected]> wrote in message
> news:[email protected]...
>> 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
>>
>>
>> --
>> Regards Ron de Bruin
>> http://www.rondebruin.nl
>>
>>
>>
>> "Caddy Shack" <[email protected]> wrote in message
> news:[email protected]...
>> > 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?
>> >
>>
>>
>
>

[Bob Phillips]

Ron,

I keep forgetting that. Thanks

Bob


"Ron de Bruin" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
news:[email protected]...
> > 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" <[email protected]> wrote in message
> > news:[email protected]...
> >> 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
> >>
> >>
> >> --
> >> Regards Ron de Bruin
> >> http://www.rondebruin.nl
> >>
> >>
> >>
> >> "Caddy Shack" <[email protected]> wrote in message
> > news:[email protected]...
> >> > 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?
> >> >
> >>
> >>
> >
> >
>
>