PDA

View Full Version : How do you make a clickable button without creating a form?



stubarny
04-07-2011, 10:04 AM
Hello everyone,

Please could you tell me how to create a clickable button without creating a form?

Clicking the button should invoke a macro and also change the appearance of the button so that it appears to have been physically pressed.

Many thanks for your help.

Stu

GTO
04-07-2011, 10:17 AM
Welcome to vbaexpress stubarny :-)

I am sure that you will like it here, there are plenty of great folks at this site.

As you just joined, and cross-posted this question at Here (http://www.mrexcel.com/forum/showthread.php?t=541948)

I would suggest reading Here (http://www.excelguru.ca/node/7)

Mark

Rob342
04-08-2011, 05:34 AM
Mark

You must be a genius or have a program thats looks at all the Forums ??

Rob