Can You Prevent A Workbook Closing? (Excel 2000)

Topic

New Reply

Hi All

I’ve had a quick search through the forums but can’t find anything related to this problem, and I don’t even know if it’s possible.

What I want to do is prevent a user from closing a workbook if certain conditions aren’t met (i.e. the values of 2 cells don’t match). Is this possible?

Reply | Quote

Replies

Yes. You can capture the ThisWorkbook BeforeClose (and ThisWorkBook BeforeSave) event, and set Cancel to True if your conditions are not met.

Reply | Quote

Ok, thanks John. I’ll give that a try.

Reply | Quote

Done it! So easy too….

Thanks muchly for that John.

Reply | Quote