Previous Topic Next Topic

Running a Macro permanently

Closed
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
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

Answer 1 / 1
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.

//ark
-Moderator/Contributor
1

Similar discussions

PC wont turn on. Fans spin loud.
juancrg -
Ififkfk -

14 responses
pc won’t display but fan runs loud
eddie -
jimmywick -

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

2 responses