Excel Macro Conflict

ccepaulb

New Member
Joined
Jan 21, 2005
Messages
7
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
 

Some videos you may like

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.

ccepaulb

New Member
Joined
Jan 21, 2005
Messages
7
Could it be some sort of security setting?
It's very strange, I have no Macros and only one string of code in the whole file. The VB code is listed below?

Private Sub CtrlCombo_Change()
' AdvFilter2 Macro
' Macro recorded 1/25/2005 by Paul
'
Sheets("Data").Range("A10:R415").AdvancedFilter Action:=xlFilterCopy, _
CriteriaRange:=Sheets("Data").Range("f1:f2"), CopyToRange:=Range("A14:R14"), _
Unique:=False
End Sub

Any Ideas?
 

bruco2

New Member
Joined
Jan 25, 2005
Messages
18
In menu Toools - Macro - Security - Security level must be set to medium. If I remember good, the default setting is High, so no macro can be executed and no dialog appears when openning workbook.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,481
Messages
5,596,399
Members
414,063
Latest member
N_Bates

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
Top