View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Aaron[_6_] Aaron[_6_] is offline
external usenet poster
 
Posts: 4
Default Close button on Custom Menu Bars


Hey thanks for the code, i'm afraid im refering to the
close 'x' button on the dialog.

If you have any ideas let me know

Thanks

Aaron

-----Original Message-----
Aaron,


I posted the following sample for an earlier question and

I think it will
help you as well:

Try the following;

'This line will toggle the entire File menu for your

workbook.
Application.CommandBars("File").Enabled = Not
Application.CommandBars("File").Enabled

'This line will toggle just the Save menu item within the

File menu for your
workbook.
Application.CommandBars("File").Controls("Save"). Enabled

= Not
Application.CommandBars("File").Controls("Save"). Enabled


In this sample I select the "Save" menu item within

the "File" menu. It
should work just as well for your custom menu if you know

the names of both
the custom menu and the button you want to disable. To

test this out I
built a simple custom menu name "SampleCommandBar" with

a "Close" button
then ran the following code;

Application.CommandBars("SampleCommandBar").Contr ols

("Close").Enabled = Not
Application.CommandBars("SampleCommandBar").Contr ols

("Close").Enabled

When I run this code the custom button toggled between

enabled and disabled.

Good luck


"Aaron" wrote in message
...

Hi all!

I would really appreciate if someone could tell me how

to
disable the close button on a custom menu bar, i have an
API for the window but i was wondering if theres one
avaliable for the custom bar?

Yours Hopefully

Aaron



.