Results 1 to 3 of 3

Thread: Toolbar Question (Self Resolved)

  1. May 9th, 2003, 11:33 AM #1
    Avatarp
    Avatarp is offline

    Thread Starter
    Fanatic Member Avatarp's Avatar
    Join Date
    Sep 2002
    Location
    Calgary
    Posts
    826

    Question Toolbar Question (Self Resolved)

    I have a custom toolbar I design in Excel. It has 1 Menu button on it with many buttons within that1 menu button. How would I ghost out 1 of those buttons that are underneith that menu button?
    Last edited by Avatarp; May 9th, 2003 at 02:04 PM.
    Reply With Quote Reply With Quote
  2. May 9th, 2003, 01:42 PM #2
    opus
    opus is offline
    I don't do your homework! opus's Avatar
    Join Date
    Jun 2000
    Location
    Good Old Europe
    Posts
    3,863
    Set the .ENABLED to FALSE.
    You're welcome to rate this post!
    If your problem is solved, please use the Mark thread as resolved button

    Wait, I'm too old to hurry!
    Reply With Quote Reply With Quote
  3. May 9th, 2003, 01:53 PM #3
    Avatarp
    Avatarp is offline

    Thread Starter
    Fanatic Member Avatarp's Avatar
    Join Date
    Sep 2002
    Location
    Calgary
    Posts
    826

    This is the proper answer for those how find this post

    Code:
        
Set MyControl = CommandBars("ButtonTest").Controls(1)
Set Ctrl1 = MyControl.Controls(3)
Ctrl1.Enabled = False
    Assuming the toolbar name is ButtonTest and there is only 1 menu button with atleast 3 buttons in the sub menu.


    But thanks opus for your insite, very valuable information there buddy
    Last edited by Avatarp; May 9th, 2003 at 02:04 PM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width