Save As - Can I use VBA? to stop XL Sheet overwrite
and if so How???
Hi everyone,
I want to somehow protect a worksheet from being overwritten. My worksheet
has passwords to open and to modify, but I hadn't realised that it was
possible to overwrite it when another xls is saved using Saved as and my
worksheet's name entered. When I tried this out with dummy files I didn't
even get a message saying that this file exists and do I want to overwrite.
Is there a built in way of stopping this happening or can a macro stop it?
I am really hoping that someone can help :-)
Thanking you in advance
--
Smudge
|