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

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

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