I have a master worksheet that I plug a few variables (Store # and Group). Based on these variables, I have formulas and an embedded macro doing things (the formulas look at different data based on the Group input and the macro hides and unhides rows based on that Group). Everything works exactly as it should...until I try to then copy this report to a new workbook and "value-out" its formulas (meaning I copy everything, then paste special - values so that the data doesn't change and the overall size of the file is reduced). I've done this a million times with other reports, but I've never had an embedded macro in the worksheet.

So I basically want to create a new workbook, without the embedded macro.

Here's the code for the embedded Worksheet Change Macro:

Please Login or Register  to view this content.
and here's my code for copying the worksheet:

Please Login or Register  to view this content.