On 5 May, 23:41, Gord Dibben <gorddibbATshawDOTca wrote:
All you uploaded was a Class Module.........*.cls

Using the the Excel Calendar Workbook *from Martin's site.

Right-click on Sheet1 tab and "View Code"

Copy/paste this into that sheet module.

Private Sub Worksheet_BeforeDoubleClick _
(ByVal Target As Range, Cancel As Boolean)
* * *OpenCalendar
* * * * *Cancel = True
End Sub

Alt + q to return to the Excel window.

Double-click on any cell.

Gord



On Mon, 5 May 2008 13:05:37 -0700 (PDT), wrote:
Hi Gord,

Thanks for getting back to me.

I've followed those step by step instructions and I can get the
calendar to pop up either with right-click or button. *What I want to
do now is have it pop up with a double-click on a particular cell, or
cells.

I've uploaded the workbook here as advised.

http://www.freefilehosting.net/download/3gk65

Thanks again.

K-Rod.- Hide quoted text -

- Show quoted text -

Hi Gord,

I'm still getting the error.

How do I upload the full workbook please?

Thanks,

K-Rod.