Macro Not Found on Sharepoint

[mthorn1210]

I created a Macro that sits in personal.xls (it is the simple date picker that I use). It works fine locally; however, I uploaded it to a sharepoint site and when another use opens the file, they enable macros, but when they fire the macro it say it errors with "http://sharepoint/filename.xls!Module1.OpenCalendar cannot be found"

Do I need to do something specific so the macro is bound to the file (something with personal.xls)?

Thanks.

 

[pboltonchina]

You need to copy the macro from Personal.xls to the file it runs on in it's own module.