View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Pawan Pawan is offline
external usenet poster
 
Posts: 87
Default Avoid 'Save As' with the same name

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