Hello
This is my first attempt at using VBA thanks to some great help from this forum.
I have been given a VBA program that keeps updating my spreadsheet every second so as to keep my real time automatically updated.
This works absolutely brilliantly except that once I save it (as macro enabled etc.) and reopen it , the VBA bit doesn't work - it remains in the VBA window and all I have to do is press the VBA run button and it works. Presumably I need to do something extra to keep it permanently working to survive after saving??
Any help would be so gratefully appreciated - out of my comfort zone (and knowledge!) here.
Mark
Bookmarks