aborting a sub

S

solo_razor

hi,

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

THX
 
J

JON-JON

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Activebook.Unprotect in macro giving errors (Pwd)#2 0
Making a macro only work on certain files 2
Insert Photo - error on cancel 2
Position to UserForm TextBox from OK_Click MsgBox 5
Sub projects added as read only in Master file which are saved on sharepoint 1
Change Default Printer Causes Abort 1
validated, stop all calculations on bad data 1
Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0

Top