Sharing Excel Calendar Macro - TechRepublic
Question
May 3, 2007 at 03:34 AM
wendaoneill65

Sharing Excel Calendar Macro

by wendaoneill65 . Updated 17 years, 3 months ago

I created a calendar pop-up in Excel using VBA. It places the date in a cell, and can be run by keyboard short cut or right clicking the mouse. All of it written in VBA and saved in personal.xls

I saved it as an add-in on a network location. I attempted to install the add-in on a different PC, and it didn’t work.

Then I saved the spreadsheet where I used the Macro as an Excel Template, on the network location.

I opened the template on another Pc and the macro did not open.

Both PC’s are running the same version of Excel. YES, I can go to the other PC and recreate the macro, but I am working remotely about 2 hours away, I’d like to avoid the drive.

Any suggestions would be appreciated.

I am sure there is something so simple I am missing!

This discussion is locked

All Comments