Hide Module for certain users

Hi Experts,

I have an excel workbook where one of the VBA module reference to a library (Solidworks in this case) that not all users have on their computer.

These users can still use the workbook as they do not need the macros related to this library, but everytime they open the workbook they get a VBA error and manually have to close the VBA interface before using the workbook.

Is there any way we can hide the module related to Solidworks to these users ?

Thanks,

The easiest way would be to convert the code to late bunding. Is would mean that no reference is added at all. You could then put error checking in to capture any issues should they try and rum those macros

I did have a look at Late binding, but it appears that late binding can only be done in subs, am I correct ?

At the moment my Solidworks module starts this way:

Please Login or Register  to view this content.

Which is following by a bunch of subs related to Solidworks.

For it to work with non-Solidworks users, do I have to put these private variables as Dim inside the subs instead ?

Thanks,

Works great !

Thanks Norie