Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Avoid 'Save As' with the same name
No.. I meant to say that excel should not allow the user to overwrite the
existing file. "Suleman Peerzade" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF isna to avoid #N/A | Excel Discussion (Misc queries) | |||
How do I save file and I avoid that others erase it in Office | Excel Discussion (Misc queries) | |||
How to avoid name ref in formula? | Excel Discussion (Misc queries) | |||
Excel - highlight new data (by date ?) and avoid 'Save As' | Excel Discussion (Misc queries) | |||
what is this, how do I avoid it? | Excel Discussion (Misc queries) |