Previous Topic Next Topic

Running a Macro permanently

Closed
Kingantz Posts 3 Registration date Monday 18 November 2013 Status Member Last seen 19 November 2013 - 19 Nov 2013 à 08:45
 Blocked Profile - 19 Nov 2013 à 09:24
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 response

Réponse 1 / 1
Blocked Profile
19 Nov 2013 à 09:24
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

Similar discussions

Fan runs so fast but cpu is not rebooting
Ai -
Johnny -

2 responses
Call of Duty black ops steam must be running
MrSalty96 -
soundtuner -

5 responses