Open workbook object
 

Hello and Season's Greetings to all! I posted a spreadsheet on our vendor
website, and now when you try to save the file or click the "Back" button,
you receive either 1 of these 2 errors:
Runtime error '9' Subscript out of range
Runtime error '1004' Method sheets of object global failed

It appears the problem occurs because I have an Auto Close macro that starts
out by putting protection back on certain sheets. I've seen an additional
file get created at some point when the code starts to run called "Object."
The first sheet name the macro is to protect does not exist in Object, and I
think that's the reason I'm getting the errors. Does anyone know how I can
stop this from happening? TIA.