Calling macro with arguments

[rlpowers45]

I created a macro to run from buttons over a set of columns to filter for Xs in the column as below

Sub SetFilter(Col)
Call Unfilter
Worksheets("Manuals QC").Range("A3").AutoFilter field:=Col, Criteria1:="X"
End Sub

(Note: Unfilter() clears all the filters)
When I originally assigned the macro to the button I put quotes around it and include the column number, e.g., "Sheet6.SetFilter(7)"
This worked great but has suddenly stopped working with an Excel error message

My work around is to create multiple subs to assign to each button but it's irritating to working code suddenly stop working. Am I missing something? Did a new Excel release occur that changed this?

Thanks in advance for advice and consolation.

 

[rlpowers45]

Build I am using MS365 and no settings come to mind that would impact that.
If you use the file that you put on the Dropbox does the button on Column G work ?

No, it gives the error message shown in the initial posting--can't run the macro. I can't think of anything I've changed. I have auto update turned on-Version 2209 Build 15629.20156

 

[RoryA]

In your Trust Center settings, do you have the option to enable Excel 4.0 macros checked? You need it (and you'll need to reopen the file after changing it).

 

[rlpowers45]

Good call, Rory! Seems to be fixed now. That may be an issue for some users that are having trouble with the macros in the rest of the app. What other Trust Center settings are required/do you recommend for working with macro-spreadsheets? Is there a tutorial somewhere that discusses this issue?

Thanks, Rory, and thanks to everyone for your inputs.

 

[RoryA]

That's the only new one that I know of, other than the new MOTW security flag that requires you to unblock files received from external sources.