Running a Macro permanently

[Closed]
Report
Posts
3
Registration date
Monday November 18, 2013
Status
Member
Last seen
November 19, 2013
-
 Blocked Profile -
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?



1 reply


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
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month