jw01
12-29-2010, 04:34 PM
hello
wondering if i can get some input from you guys regarding my macro
seem to be getting an issue that is lagging my report behind.
i have 4 buttons on my userform
1) sign-off ....2) clear ....3)cancel.....4) save/close
3) cancel appears to be giving me issues, as everytime i hit cancel, it should technially just exit or "hide" the userform for the individual to make changes or w.e to the file.
-the userform is triggered when the person exits the file (before close)
but everytime i hit cancel, it goes to save, and pretty much closes the file in a way.
can someone pls help
Public blnCancelled As Boolean
Private Sub cmdCancel2_Click()
blnCancelled = True
Me.Hide
End Sub
Private Sub cmdSaveClose_Click()
ActiveWorkbook.Save
Unload Me
End Sub
and this code is in my userform module...and for some apparent reason, when i click on "cancel' button as i mentioned before, it does not close or hide the user form, instead ask me save and closes the file. any input would be very appreciated! pls adn thxs agani!
wondering if i can get some input from you guys regarding my macro
seem to be getting an issue that is lagging my report behind.
i have 4 buttons on my userform
1) sign-off ....2) clear ....3)cancel.....4) save/close
3) cancel appears to be giving me issues, as everytime i hit cancel, it should technially just exit or "hide" the userform for the individual to make changes or w.e to the file.
-the userform is triggered when the person exits the file (before close)
but everytime i hit cancel, it goes to save, and pretty much closes the file in a way.
can someone pls help
Public blnCancelled As Boolean
Private Sub cmdCancel2_Click()
blnCancelled = True
Me.Hide
End Sub
Private Sub cmdSaveClose_Click()
ActiveWorkbook.Save
Unload Me
End Sub
and this code is in my userform module...and for some apparent reason, when i click on "cancel' button as i mentioned before, it does not close or hide the user form, instead ask me save and closes the file. any input would be very appreciated! pls adn thxs agani!