SiChambo
05-08-2013, 06:05 AM
I have found a fantastic fix (that was developed by Lucas)), that lets me resolve 85% of an issue I have been presented with, with the ID ref no as id=587. See article
vbaexpress.com/kb/getarticle.php?kb_id=587
My question is how do I close this work book without saving?
What I mean is, should the user not have all the detail in front of them to complete the work sheet then prevent them from saving the work book partially complete, and give them the option to either proceed and complete the sheet in full before saving or exit without saving?
At present I can open it but cannot close it at all without completing it, which worries me as the user will just put anything in the mandated cells just to get it off his screen.
Please advise
I am learning fast with VBA but not fast enough
vbaexpress.com/kb/getarticle.php?kb_id=587
My question is how do I close this work book without saving?
What I mean is, should the user not have all the detail in front of them to complete the work sheet then prevent them from saving the work book partially complete, and give them the option to either proceed and complete the sheet in full before saving or exit without saving?
At present I can open it but cannot close it at all without completing it, which worries me as the user will just put anything in the mandated cells just to get it off his screen.
Please advise
I am learning fast with VBA but not fast enough