Use exit sub for example
if thisworkbook.readonly then
'do stuff
else
Exit sub
end if

How this is what you need.

regards,

Jon-jon

"solo_razor" wrote in message
...
hi,

does anybody know how i can abort a sub using the if then else
statement?

THX



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/