Macro to hide columns in Excel 2007

I have written a macro to hide any column (within a range of columns) that has an 'x' in it. By putting the 'x' in the column, it allows the allows the user to choose what columns they want to hide. I have an inverse macro as well that unhides those hidden columns.

These macros work perfectly in Excel 2003, but they do not work in Excel 2007. In Excel 2007 I get a compile error: can't find project or library. As a note, all other macros in my spreadsheet (Module 1) work.

Could somebody help me to get these to work in Excel 2007? Here is the macro to hide columns that does not work in Excel 2007:

Please Login or Register  to view this content.

Any suggestions?

Nothing wrong with the code. Works fine in xl2007.

Go to the VBE and use Tools > References, and check for any Missing entries.