Forum Discussion
seakingwarrior
Jun 17, 2020Copper Contributor
Autorun Macro VBA on opening workbook
Hi there, I have a Macro for a scrolling marquee which works fine but I'm just trying to get it to run on opening the workbook. Any suggestions? No issue with the Macro, just activating autorun....
JKPieterse
Jun 17, 2020Silver Contributor
Move the code starting from "Sub DoMarquee" up to the line starting with Application.OnTime to a normal module (From the menu: Insert, Module). Make sure both subs in both places have End Sub at their ends.