Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to: Open closed workbook/Search data tables/Return data to open workbook | Excel Discussion (Misc queries) | |||
how do i open a data workbook when i open a timesheet workbook | Excel Discussion (Misc queries) | |||
How do you program so that Workbook B cannot be open unless Workbook A is open? Plus I need to validation | Excel Programming | |||
Load a Combo Box Object upon workbook open | Excel Programming | |||
Excel 2003 Workbooks.Open with CorruptLoad=xlRepairFile fails on Excel 5.0/95 file due to Chart, with Error 1004 Method 'Open' of object 'Workbooks' failed | Excel Programming |