Auto Run Failure

Question

I have a macro set to auto run using the "This Workbook" option. It used to work fine. Then it stopped - except when I copy the workbook to a new name. Then when I open the workbook for the first time and "enable content" the macro auto runs. But on subsequent opening of that workbook the macro does not run. Any suggestions on a fix?

Answer 1

OK, thanks. I've moved over to Stack Overflow.

Answer 2

Hi Tom Reedy1,

Thanks for your post in Microsoft Community.

Based on your description, it seems like that you're encountering macros related issue.

Well, there is a better place to publish which is Stack Overflow.

Ask VBA programming questions to Stack Overflow by using the VBA tag along with any other relevant tags.

Please note that Stack Overflow includes guidelines, such as requesting a descriptive title, a complete and concise problem description, and sufficient details to reproduce your problem. Feature requests or questions that are too broad are considered off-topic.

Disclaimer: Microsoft provides no assurances and/or warranties, implied or otherwise, and is not responsible for the information you receive from the third-party linked sites or any support related to technology.

I can't help you, but I'll leave this question open in case one of our great volunteers has ideas for you.

Best regards,

Thomas C - MSFT | Microsoft Community Support Specialist