Posted to microsoft.public.excel.programming

external usenet poster

Posts: 866

BeforeDoubleClick doesn't seem to work

I have this code in my project, and double clicking on the sheet doesn't
appear to do anything:

Public Sub BeforeDoubleClick(ByVal SelRange As Range, Cancel As Boolean)
Cancel = True
msgbox "Range= " & SelRange
End Sub

What am I doing wrong?

Thanks -
Dan

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
BeforeDoubleClick processing question(s)	Forms / Send to .....VBA or Macro?	Excel Programming	2	November 8th 06 04:06 AM
BeforeDoubleClick Cancel=True not working	Reggie	Excel Programming	1	September 20th 05 03:43 AM
beforeDoubleClick (target, true)	mark kubicki	Excel Programming	2	May 10th 04 10:33 PM
Selective protection of charts - permit only beforedoubleclick?	Jon Peltier[_5_]	Excel Programming	0	January 23rd 04 11:41 PM
Selective protection of charts: permit only BeforeDoubleClick ?	David Powell	Excel Programming	0	July 14th 03 01:14 AM

All times are GMT +1. The time now is 05:26 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us