Auto Close XLS

[GreenthumbUK]

Hello,

What I'm trying to do is when a workbook is opened a check will be performed and if it fails the workbook will close without saving.

It's the closing without saving I'm struggling with...?

Thanks

 

[ETID]

Activeworkbook.saved=true
Application.quit

 

[xlbo]

Activeworkbook.close(false)

Rgds, Geoff

Never test the depth of water with both feet

Help us to help you by reading FAQ222-2244 before you ask a question

 

[ETID]

...or that

 

[GreenthumbUK]

thanks for all your help ppl