Hi all,

I am a newbie in VBA. I have a addin that count colour cell in a worksheet. It work well in local drive but the formula not working when other user access it in share drive. Even they have the script because the username in the formula is different.

example : me xxxxxxxxxxxxxxxxx

='C:\Users\xxxxxxxxxxxxx\AppData\Roaming\Microsoft\AddIns\countcolour.xlam'!CountCcolor('V:\1.0 CDPU\CDPU Attendance\[Consumer Support 2016.xlsx]Feb'!$AC$9:$AH$9,Sheet3!A1)


when user YYYYYYYYYYYY open the file from the shared drive it not working because it still have the user xxxxxxxxxxxxxxxxxxxxx

='C:\Users\xxxxxxxxxxxxx\AppData\Roaming\Microsoft\AddIns\countcolour.xlam'!CountCcolor('V:\1.0 CDPU\CDPU Attendance\[Consumer Support 2016.xlsx]Feb'!$AC$9:$AH$9,Sheet3!A1)




I tried to install the addin to user y pc and also put the vba code in share drive. Is there any way to work around?


Thank you.