Hi there,
I've got a basic macro that updates the information on screen every second. How can I get it to run automatically when I open the spreadsheet?
THis is what I currently have, which isn't working.
Thanks
Please Login or Register to view this content.
Last edited by AliGW; 04-11-2024 at 06:54 AM. Reason: Code tags added - please review the forum guidelines.
To Add Excel VBA Code to a Workbook / This Workbook Module
- Copy the code that you want to use
- Select the workbook in which you want to store the code
- Hold the Alt key, and press the F11 key, to open the Visual Basic Editor
- In the Project Explorer, find your workbook, and open the list of Microsoft Excel Objects
- Right-click on the ThisWorkbook object, and choose View Code
- Where the cursor is flashing, choose Edit | Paste
Please Login or Register to view this content.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Rather:Originally Posted by :) Sixthsense :)
Please Login or Register to view this content.If you would like to use an older type of code (Auto_Open) that runs when the workbook is opened, like this (in standard module, eg. Module1):Please Login or Register to view this content.When you have more than one sheet in the workbook (and also when you have only one), you should indicate in which sheet you want to recalculate cell K8:Please Login or Register to view this content.
ArtikPlease Login or Register to view this content.
That's great, works perfectly. Thank you both.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks