macro error

[cmccabe]

I have a macro that is called PERSONAL.XLS!OpenCalendar that is refereced in by a VBA code. It works great when it is run on the user who created the spreadsheet computer, but others get a PERSONAL.XLS does not exist error and can not be accessed. Can this be fixed? Thank you very much.

 

[Trevor G]

Place a copy of the macro in the workbook that you want to use it in then you can run it from the workbook.

Person Workbook is a user PC specific thing.

 

[cmccabe]

Once the macro has been copied into the workbook do I need to change the code below. Thanks.

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
     Application.Run "PERSONAL.XLS!OpenCalendar"
End Sub

 

[Trevor G]

If its in your workbook now then you would just call it

so like this

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
Call OpenCalendar
End Sub