View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Lp12 Lp12 is offline
external usenet poster
 
Posts: 54
Default Capture a cancel button

Hi all,
I record a macro that unprotect a sheet and attached it to a form button.
When i click the button the unprotect sheet (coming from the application)
form appears. the problem is that if i click the 'Cancel' button the rest of
my code is still executed.(this i want prevent). how can i trap the cancel
event and prevent it from executing the rest of the code?
Thanks in advance