PDA

View Full Version : Solved: Macro embedded in workbook



Klartigue
06-07-2012, 07:03 AM
I have a written a macro for an excel document. I am trying to email this excel document and macro to someone so they can test how it works. Is there a way to create a shortcut/somehow have a "button" embedded in the worksheet that will run the macro when you press it or do the short cut key?

Opv
06-07-2012, 07:56 AM
I have a written a macro for an excel document. I am trying to email this excel document and macro to someone so they can test how it works. Is there a way to create a shortcut/somehow have a "button" embedded in the worksheet that will run the macro when you press it or do the short cut key?

You can create a button from the Forms toolbar and then assign the macro to it.

Klartigue
06-07-2012, 12:23 PM
Ok, ill try that. Thanks