Thread: Cancel RefEdit
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dr.Schwartz Dr.Schwartz is offline
external usenet poster
 
Posts: 39
Default Cancel RefEdit

I have a refedit control on a form. Once the user activates the control I
would like to have an event that checks if a certain sheet is selected. If
false then I want to cancel the action so that the user doesn't get to select
a range and is returned to the form. Can this be done?

Any help is apriciated
The Doctor