Consulting

Results 1 to 4 of 4

Thread: Solved: Unusual Command Buttons

  1. #1

    Question Solved: Unusual Command Buttons

    In my surfing around looking for information on Excel I have run across some interesting command buttons that aren't normal. I'm not sure what they are exactly but they will mouse over in design mode and cannot be selected. They have no code associated with them on the sheet. Can anyone tell me what these are and how they might be created? I've written to the author and asked him but haven't received any response.

    I think posting a link to a downloadable XL example is the best way to describe what these are ...
    http://www.xl-logic.com/xl_files/vba/auto_copy.zip

    Thanks,
    Ken

  2. #2
    Site Admin
    Jedi Master
    VBAX Guru Jacob Hilderbrand's Avatar
    Joined
    Jun 2004
    Location
    Roseville, CA
    Posts
    3,712
    Location
    One is an AutoShape, the second is a Text Box. Both added from the Forms toolbar.

    The AutoShape has a macro assigned to it. Right click on it and select Assign Macro.
    The Text Box has a hyperlink in it. Right click on it and select Edit Hyperlink.

  3. #3
    Hi Jacob,
    Thanks for the answer ... I haven't got enough experience with VBA to recognize what certain things are. I looked under the hood but only saw the module which confused me. Got it now ... thanks again.
    Ken

  4. #4
    Site Admin
    Jedi Master
    VBAX Guru Jacob Hilderbrand's Avatar
    Joined
    Jun 2004
    Location
    Roseville, CA
    Posts
    3,712
    Location
    You're Welcome

    Take Care

Posting Permissions

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