Disable macro if sheet exist

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Charles Reid - 26 Oct 2007 01:22 GMT

hello all,

is it possible to disable a macro in excel if a sheet exist.

I have a macro that creates several sheets. I would like to disable that
macro once the sheets are created. Is that possible. I am asking because I
mistakenly ran that macro again and it created more sheets.

Thanks in advance

Reply to this Message

Jim Cone - 26 Oct 2007 02:14 GMT

At the beginning of your current macro, something like ...
If Worksheets.Count < 6 then
'create sheets
Else
Exit Sub
End if

Signature

Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)

"Charles Reid"
wrote in message
hello all,

is it possible to disable a macro in excel if a sheet exist.
I have a macro that creates several sheets. I would like to disable that
macro once the sheets are created. Is that possible. I am asking because I
mistakenly ran that macro again and it created more sheets.

Thanks in advance

Reply to this Message