Reset project on open?

**geoB** · 03-24-2009, 10:46 PM

XL2007, sp1:

I'm a noob to programming in XL, and am teaching myself through a project for manipulating vectors. One thing that has me stumped is that when I open the file in which I'm working, I get a "This action will reset your project..." message.

Why? Where do I look?

TIA,

George

**shg** · 03-24-2009, 11:21 PM

Dunno. Post the code.

**geoB** · 03-24-2009, 11:28 PM

I've attached my training ground. (Hoped there was a simple explanation.)

Thnx.

g

**shg** · 03-24-2009, 11:46 PM

What do you do that results in this message?

**geoB** · 03-25-2009, 08:21 AM

To get the reset message I've saved and closed the file. Then the first thing that appears when the file is reopened is "This action will reset your project..."

g

**shg** · 03-25-2009, 08:39 AM

The message occurs when you enable macros, correct? It's harmless, but if you don't want to see it, in the VBE, do Tools > Options > General, untick Notify before state loss.

**geoB** · 03-25-2009, 09:20 AM

Very nice! Thank you.

Does this setting follow the workbook? I expect not. Can it be set in code?

I ask because my goal is to provide this to my students.

And thanks again.

George