Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
STOP MACRO IF CELL "A1" IS EMPTY OR SHEET DOESN´T EXIST
Hi everybody,
I´ve got a problem. I have validation list with the name of the rest of the sheets of the book in "A1", and a commmand button that deletes the selected sheet in that A! cell. When cell is empty or the selected sheet has already been deleted, the macro deletes the sheet in which the validation list is, and i´d like it to stop the macro if these happens. Any idea? With my best wishes for this incoming year, yours CBM |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
STOP MACRO IF CELL "A1" IS EMPTY OR SHEET DOESN´T EXIST
Can we see the code to see how that all happens?
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "cbm" wrote in message ups.com... Hi everybody, I´ve got a problem. I have validation list with the name of the rest of the sheets of the book in "A1", and a commmand button that deletes the selected sheet in that A! cell. When cell is empty or the selected sheet has already been deleted, the macro deletes the sheet in which the validation list is, and i´d like it to stop the macro if these happens. Any idea? With my best wishes for this incoming year, yours CBM |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
STOP MACRO IF CELL "A1" IS EMPTY OR SHEET DOESN´T EXIST
ve el foro en español
Saludos -- Atte. ?T Francisco T? http://groups.msn.com/ExcelVbaMacrosOffice El verdadero buscador crece y aprende, y descubre que siempre es el principal responsable de lo que sucede. Jorge Bucay La oscuridad nos envuelve a todos, pero mientras el sabio tropieza en alguna pared, el ignorante permanece tranquilo en el centro de la estancia. Anatole France |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
a Macro to "save as" filename from a cell on the sheet and then pr | Excel Discussion (Misc queries) | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
Stop the "Personal" sheet from popping up every time I open a work | Excel Discussion (Misc queries) | |||
Change default in input box from "20" to "000000"? Have macro continue on to name sheet tab? | Excel Programming | |||
Stop users from accessing "Protection" option from "Tools" menu | Excel Programming |