Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add-in
Hello,
I have several macros that use the SumByColors function created by: http://www.cpearson.com/excel/colors.htm This allows me to sum by color. I have set this up as an Add-in used by several individuals. When I run one of my macros that uses this function and then save the file to my network drive the file continues to link to my C: drive where the Add-in is stored. When other users (who also have the Add-in installed on their C: drive) access this file from our network drive the formulas for the SumByColor function is still linked to my C: drive. How can I set up the macro or the Add-in to allow the file to link to the users C: drive or Add-in and not to the computer that creates the file (my C: drive). Any thoughts would be helpful. Thank you, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|