Macro Written, but I need to automate (Execute on Opening the XLS) with the Ctrl+M automatically. Right now, I have to physically open a spreadsheet, then physically hit the Ctrl + M to execute the macro. I need this automated, and can't figure out how to do this? Any help that can be provided would appreciated. I will attach the two files, one the EnergyReport2.xl;s put on the desktop and then open the enabled-macro
Hi,
Neither of the files you attached seems to contain a macro. However in order to get a macro to run just include the name of the macro in the Workbook_Open event of the workbook in question.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Can you explain where and how to do this. I am not a coder and don't do this stuff for a living. Thanks.
...but neither of the files contain a macro despite your OP starting out with the comment 'Macro Written'
What is the macro code if it's already written.
If not please explain in detail what you are trying to do step by step.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks