About excel addin

hsk

Well-known Member
Joined
Oct 19, 2006
Messages
567
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....
 

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.
Still no ans ......... i am surprised .........
Is the question not clear?
 
Upvote 0

Forum statistics

Threads
1,215,328
Messages
6,124,299
Members
449,149
Latest member
mwdbActuary

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top