I have written some macros and to make it simple to use for user i have combined them to form an "addin" ..... the code is locked for view. It has a macro which run on "Workbook_Open" event and adds new menu/buttons to tool bar and assigns macros....
I sent this addin to many friends ..... for few it works fine while for for some of them .......... they are getting errors while opening like ......
"compile error in hidden module"
"can't find project or library"
"VBA project password block"
I don't know the reason why it working for few and not for others .....
Is this have to do with the security level or the version (Office 2K etc..) ??
Are there any settings that needs to be done to allow the macros in addin to run....
I sent this addin to many friends ..... for few it works fine while for for some of them .......... they are getting errors while opening like ......
"compile error in hidden module"
"can't find project or library"
"VBA project password block"
I don't know the reason why it working for few and not for others .....
Is this have to do with the security level or the version (Office 2K etc..) ??
Are there any settings that needs to be done to allow the macros in addin to run....