Macros in Excel

[boycee]

I have a macro enabled file that I use each day for football. I open the master file and save it as a macro enabled file for that date. When I try to run the macros it always opens the master file to run it. How do I save the daily file so that it runs on its own without opening up the master file?

[osknows]

Difficult to say exaclty without seeing your code, but I suspect when you open the master a macro runs based on the workbook_open event which then runs some code with the following

Application.OnTime Now + TimeValue("xx:xx:xx"), xxxxxxx

This will open any closed workbook to run the code.

An easy workaround is to make a copy of the master excel file without opening it in excel, rename and then open.

[boycee]

An easy workaround is to make a copy of the master excel file without opening it in excel, rename and then open.

Thanks os

Tried to copy and rename master without opening it, but still opens original file.

[osknows]

If you PM me a link to the file I can take a look

[boycee]

Thanks os but I just cracked it.

When I built the original master file I put the macros on the Quick Access Toolbar for ease of use. Seems that when you copy a file which has the QAT in operation this is what is causing my problem.

I deleted the QAT icons and re-did the macros normally, then hey presto when you save the master as a new macro enabled file - it does the business.

Thanks for your input and suggestions os.