Excel file will NOT save
 

I have Excel 2002.

Intermittently, when I try to save the workbook I get a vbExclamation dialog
box that says "Document will not save".

I've been doing a fair amount of vb macro writing and testing. The only odd
thing I do, is that sometimes I'll make a change to a procedure, minimize it
(but not close) the vb editor and run the macro.

workbook is about 1.4 million bytes. 12 worksheets.

As I work, I've been saving the workbook about every 10 minutes.

What can I do to prevent this from happening. I don't like to lose the work
I've done.
What are the likely causes for the message from Msoft?

Thanks.
--
Neal Z

Excel file will NOT save
 

Hi Neal

Try to clean up your code with this Add-in
http://www.appspro.com/Utilities/CodeCleaner.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl



"Neal Zimm" wrote in message ...
I have Excel 2002.

Intermittently, when I try to save the workbook I get a vbExclamation dialog
box that says "Document will not save".

I've been doing a fair amount of vb macro writing and testing. The only odd
thing I do, is that sometimes I'll make a change to a procedure, minimize it
(but not close) the vb editor and run the macro.

workbook is about 1.4 million bytes. 12 worksheets.

As I work, I've been saving the workbook about every 10 minutes.

What can I do to prevent this from happening. I don't like to lose the work
I've done.
What are the likely causes for the message from Msoft?

Thanks.
--
Neal Z

Excel file will NOT save
 

Thanks Ron, it's downloaded and I'll give it a try.
Neal Z


"Ron de Bruin" wrote:

Hi Neal

Try to clean up your code with this Add-in
http://www.appspro.com/Utilities/CodeCleaner.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl



"Neal Zimm" wrote in message ...
I have Excel 2002.

Intermittently, when I try to save the workbook I get a vbExclamation dialog
box that says "Document will not save".

I've been doing a fair amount of vb macro writing and testing. The only odd
thing I do, is that sometimes I'll make a change to a procedure, minimize it
(but not close) the vb editor and run the macro.

workbook is about 1.4 million bytes. 12 worksheets.

As I work, I've been saving the workbook about every 10 minutes.

What can I do to prevent this from happening. I don't like to lose the work
I've done.
What are the likely causes for the message from Msoft?

Thanks.
--
Neal Z