Re: Disable File, Edit, View, etc. command bars

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Danny (anonymous_at_discussions.microsoft.com)
Date: 03/16/04 

Date: Tue, 16 Mar 2004 10:06:29 -0800

Hi Ron,

Thanks a lot, AGAIN!

Regards,

Danny

>-----Original Message-----
>Hi Danny
>
>For all
>
>Sub test()
>Dim myCmd As Object
>On Error Resume Next
> Set myCmd = CommandBars("Worksheet menu bar")
> For a = 1 To myCmd.Controls.Count
> myCmd.Controls(a).Enabled = False
> Next
>End Sub
>
>
>For one
>Application.CommandBars("Worksheet menu bar").Controls
("File").Enabled = False
>
>Whole menubar
>Application.CommandBars("Worksheet menu bar").Enabled =
False
>
>
>--
>Regards Ron de Bruin
>(Win XP Pro SP-1 XL2000-2003)
>www.rondebruin.nl
>
>
>
>"Danny" <anonymous@discussions.microsoft.com> wrote in
message news:e19f01c40b7c$a930e2a0$a301280a@phx.gbl...
>> Is there away to disable ONE or MORE of the File, Edit,
>> View, Insert, Format, Tolls, Data, Window and Help
command
>> bars?
>>
>> Thanks
>>
>>
>
>
>.
>

Relevant Pages

  • Re: Column Property, Indirect reference?
    ... Sub Test() ... Dim lngCol As Long ... Dim lngRow As Long ... Regards, ...
    (microsoft.public.excel.programming)
  • Re: Biztalk 2004 XML Assembler
    ... The convoy is indeed the solution to my problem. ... Danny ... > document to the send port... ... >> Regards, ...
    (microsoft.public.biztalk.general)
  • Re: range division
    ... myarr = rngCopy.Value ... Sub test() ... Regards, ... num) ...
    (microsoft.public.excel.programming)
  • Re: Starting A Part-Time Coffee/Espresso Bar
    ... > Firstly, as I said I wasn't discouraging the OP, merely offering practical ... being a prat or behaving prattishly has nothing to do ... Danny, ... Regards, ...
    (alt.coffee)
  • forgot my Windows XP Password
    ... out how to overcome this could u email me the remedy to ... regards. ...
    (microsoft.public.windowsxp.security_admin)