Excel Multi-user problem

[ccepaulb]

I have an Excel sheet I designed fo for our sales people to use.
It has some VBA code written in it that will run an advanced filter function based on a users selection from a drop down box from the control toolbox.
Problem is that it runs fine on my PC and runs fins on another users PC, but not on all when tested.
For some reason on a select few PC's the Macro enable/disable diaolg box does not even show up when they open the file (does on all PC's where the file actually operates).
It almost seems like it is forcing a macro disable on a few PC's?

Can anyone tell me what could be going on here?

Thanks, Paul

 

[gizmo1973]

Have you checked the security options?
If it is set to High the macro won't run unless it is from a trusted source.
The setting you refer to is Medium wherby the user is asked wheteher to run Macros or not

Tools/Macro/Security/Your setting.

Regards, Phil.

M.U.F.C. Show your true support here:

http://shareholdersunited.org/join.php?ref=125059000

"Shares not Shirts