In the end, I was unable to find the source of the error. In Both XL 9
and 2000, the VBA debugger flagged the "ThisWorkbook.Save", an
"Me.Save", and "Activesheet.Save" as the offending lines of code.
Based on the knowledgebase articles I posted above, I tested to see i
the systems had the NT bug. I did this by opening new spreadsheets an
writing simple macros that saved themselves with the code above.
Worked fine.
I also tested the VBA Password protect bug by removing all m
passwords. Did not solve the error.
I eventually had to remove all lines of code that attempted to save th
spreadhseet programically, and instead am forced to rely on the user t
save their work.....
Weird bug
--
Message posted from
http://www.ExcelForum.com