Running a Macro permanently

Kingantz Posts 3 Registration date Monday November 18, 2013 Status Member Last seen November 19, 2013 - Nov 19, 2013 at 08:45 AM
 Blocked Profile - Nov 19, 2013 at 09:24 AM

I have copied and edited a Macro to a workbook to save a certain cell as the file name. The problem is that you have to click on Macros find the macro and then run for it to work.

Anything I can do to make it happen?

1 response

Blocked Profile
Nov 19, 2013 at 09:24 AM
Good Morning,

Attach a "hotkey" or short-cut key. Like CNTRL-P.

You could also detect a double click on a cell.

You could also attach a VBA button onto the sheet.

I hope this helps.