View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Minitman Minitman is offline
external usenet poster
 
Posts: 293
Default Worksheet_BeforeDoubleClick Stops Working

Greetings,

I have a Worksheet_BeforeDoubleClick event looking if I have double
clicked either column A or C and then reacts accordingly. Double
clicking on column A opens up a UserForm. Double clicking on column C
opens a new workbook to print chosen record

Both of these operations work fine until I change some code in a
UserForm. For some reason, when I go to test the changes I made to
some of the controls on that UserForm, the Worksheet_BeforeDoubleClick
event doesn't fire on either column!!!

If I save changes then close and reopen this workbook, then
Worksheet_BeforeDoubleClick is working again.

Any ideas as to what could cause this problem? It is really getting
annoying.

Any help would be appreciated.

-Minitman