Forced save

[ChrisUK]

Hi,

We have a problem at work using Excel 2003. For some reason intermittently if we make a change to a workbook Excel insists we save it before we are allowed to close it.

A dialog box pops up and you get asked the question "Would you like to save this" and three buttons appear - Yes, No and Cancel but the No button is greyed out!!

Its easy to get round I know, save it as book1 and then delete it ... but one day someone will accidently press the yes button and destroy the workbook! I'm sure there is a simple enough fix, but what is it?

Anyone out there seen this before and know of a solution?

Thanks

Chris

 

[ColinKJ]

Hi Chris,

You would be able to stop this with a macro in the BeforeSave event, but are there any circumstances when you do want to save it, because if so, you would need to program in what these circumstances are, otherwise you would never be able to save it.

Regards

ColinKJ

 

[ChrisUK]

Thanks Colin.

I should have clarified, this is happening on more than one workbook.

Whilst I can see its possible to do this using a macro it doesn't make it right. The problem still exists and I don't see why. The question is do you want to save? which implies you should be able to answer yes or no at least not just yes. I can't help feel there is a reason for this, some registry entry maybe a local config file perhaps ...

Chris

 

[ColinKJ]

Hi Chris,

Sorry Chris, as you say, if it's with more than just the one WB it must be a setting.

I can't help, but I'm sure someone on this site who can.

Is there anyone out who can help Chris !!!!!

ColinKJ