PDA

View Full Version : Solved: Unusual Command Buttons



SparrowHawk
08-31-2004, 03:10 AM
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? :confused: 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

Jacob Hilderbrand
08-31-2004, 03:56 AM
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.

SparrowHawk
09-01-2004, 03:54 AM
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

Jacob Hilderbrand
09-01-2004, 04:29 AM
You're Welcome :)

Take Care