Running a Macro permanently Closed

Question

Hello, 

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?



Configuration: iPhone / Safari 7.0

ac3mark · Answer

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. 
 
//ark
-Moderator/Contributor

Running a Macro permanently

1 response

Similar discussions

Subscribe To Our Newsletter!