| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
add eventhandler to sheet in code
Hi,
I'd like to attach the eventhandler below, to any sheet that I add in code like so : Set wsUpload = ThisWorkbook.Worksheets.Add Private Sub Worksheet_BeforeDoubleClick(ByVal target As Range, Cancel As Boolean) Call bereikenmaken If target.Column = Range("womschrijving").Column Then Load Ingave Call tonen(target) Ingave.Show End If End Sub How can I do that ? thx Ward |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Display one sheet or two userforms while code is vba code is runningon another | Excel Programming | |||
| Code to change code in a sheet and workbook module | Excel Programming | |||
| Udfs and eventhandler for excel in managed code | Excel Programming | |||
| Protect Sheet with code, but then code will not Paste error. How do i get around this. Please read for explainations.... | Excel Programming | |||
| excel - macro code to open a protected sheet, enter passowrd, and then protect sheet | Excel Programming | |||
Threaded Mode
