Is this possible ?

[Chance1234]

Sub Bob()

Frmmain.show

Beep

End Sub



what i want to do is when frmmain loads up is to totally exit sub bob so when i close the form it doesnt beep. before anyone goes why not just take out the line beep

funnly enough that isnt actuallty my code, what i haev got is a class module set up which fires events in powerpoint but the problem is that on the auto_open it is holding values that i cant get rid of without getting out of the sub

Chance

http://WWW.5YLAC.S5.COM

 

[ETID]

Sub Bob()

Frmmain.show

if "your condition here"=true then exit sub else Beep

End Sub

 

[Chance1234]

nice try ETID but ;

what i need to do is exit the sub on the frmmain.show

http://WWW.5YLAC.S5.COM

 

[euskadi]

If the form is not modal "showmodal = false" then your sub should complete after the form is opened.

 

[Chance1234]

thats the thing i dont want the sub to complete

http://WWW.5YLAC.S5.COM

 

[ETID]

Do you want the form to be visible after exit?