Thread: Call Calendar
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Steen Steen is offline
external usenet poster
 
Posts: 104
Default Call Calendar

Hi

I am using the calendar code from Ron de Bruin's site put in PERSONAL.XLS:
http://www.rondebruin.nl/calendar.htm

I want to call OpenCalender from Sheet2:

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As
Boolean)
If Target.Row 4 And Target.Column = 6 Then
Cancel = True
Call OpenCalendar
End If
End Sub

But I get the errormessage "The macro 'test.xls!Module1.OpenCalendar' cannot
be found"

I seems that it can't "see" the macro in PERSONAL.XLS - any solutions, what
am I doing wrong.

/Steen