My battle with an auto close timer macro continues. I have 7 files that are the exact same (except minor things are different like drop down lists). But the macros all have a user form that takes the entered data, dumps it into a worksheet table, opens a master file (in the same folder), dumps into a table.
I added a timer this morning from another page on there. I copied the timer code from someone on this site (thank you). Let's see if I do this right:
On a worksheet where the data table exists:
On "This Workbook"
On a Module:
I also have test workbook....just like the others where I try things out. Now that I've loaded all the code, something in this keeps trying to open worksheets. My question:
Does "Public EndTime" have to be "public" and could it be causing the worksheets to try to open? It's so weird....I have nothing that says other worksheet names in the code. It also happens random times which makes me think it has something to do with the last time I opened the file. When the files are closed, I don't want this timer running and doing stuff.
Suggestions please!
Bookmarks