Userform works on my computer, but no one elses, and I can't figure out why....

**lordterrin** · 03-05-2014, 06:59 PM

Hi there,

I have a button that links to a userform, with the following code:

Please Login or Register  to view this content.

The important part of this is the sub GetTheList(), which creates a list of all macros in my workbook which start with the letters DW. For some reason, when anyone else tries to open this workbook on their computer, they click the button which operates this macro, and they get zero results, but it works perfectly for ME.

What setting might I have enabled that is causing this to work that they are not? I can't figure out why this would not be functioning correctly!

**Izandol** · 03-05-2014, 07:10 PM

Why do you add this reference at runtime and not set it once at design time?

**Izandol** · 03-05-2014, 07:13 PM

I think probably other users do not have trusted access to VBA project set in Trust Center but On Error Resume Next hides this problem.

**lordterrin** · 03-10-2014, 11:26 AM

Originally Posted by Izandol

I think probably other users do not have trusted access to VBA project set in Trust Center but On Error Resume Next hides this problem.

Perfect - I'm so used to On Error Resume Next being there that I don't even see it. I'll remove this and have a look at what exactly is the problem, but I'm thinking you're correct.