Hi
o.k. maybe a little bit difficult to explain but I'll give it a try
- open the VBA editor
- locate your code and goto the first line of your save macro
- hit F9 (this inserts a breakpoint)
- now in Excel start the macro manually. The VBA editor should be
opened with the cursor placed in the line of your breakpoint.
- Now step line by line through your macro (hit F8 for this).
See what happens with your macro, check the values, etc.

--
Regards
Frank Kabel
Frankfurt, Germany


what do you mean by breakpoint....place this in the auto-save macro
or
the macro that prevents saving?

Breakpoint meaning...pick a spot and End the sub prematurely?


---
Message posted from http://www.ExcelForum.com/