View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Suleman Peerzade[_2_] Suleman Peerzade[_2_] is offline
external usenet poster
 
Posts: 189
Default Avoid 'Save As' with the same name

It is by default (Hard coded)
--
Thanks
Suleman Peerzade


"Pawan" wrote:

I have a folder with several excel sheets in it. All carry same name except
one digit different. I want to disable 'Save As' with the same name. If by
mistake user gives the name which is already existing, then excel will ask if
he wants to overwrite. Use can select 'Yes' by mistake, which I dont want! In
short, overwriting the excel sheet with existing sheet name should be
disabled.

Any suggestion is appreciated.

Thank You

Pawan