Excel 2007 - Help please? My simple auto filter macro's refuse to run. "Cannot run the macro...."

[Kithera]

Hi guys, I'm admitting first that I'm not a programmer. I created a spreadsheet for some users. Each column has an autofilter on it. Only some of the users panic if they don't know how to use an auto-filter and think that they've lost all the data thats filtered. So I used the forms buttons and put in two buttons. One is "show all issues" and one is "show open issues". The macros were simply to filter all the issues for either showing everything or the sub-set of only open. I assigned the macro's to the buttons and they all worked. I saved it and closed excel. Then on opening the buttons dont work anymore. I did go into the trust center and enabled all macros, and I "trusted access to vba....". the macros still don't work. I have to send this out to a bunch of different users and really want those buttons to work.

Any help you can give would be appreciated!

 

[dermie_72]

the the macros still linked to the buttons?

Were the macros on that workbook on your personal one?

If the macros are still linked and they still don't work, please post your code, so we can assist.

 

[prince141987]

Can you please see if the file extention is xlsm ie a macro enabled workbook. Or you can share your workbook with me.

Regards
Prince

 

[Kithera]

OMG - I totally love you. I didn't even know you could save something as a macro enabled workbook. So now I just have to see if the clinical planners can open it.