View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Smudge Smudge is offline
external usenet poster
 
Posts: 53
Default 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