View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
jasonsweeney[_54_] jasonsweeney[_54_] is offline
external usenet poster
 
Posts: 1
Default help: Activesheet.save error with XL 2000

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