NPrinting Excel Macro error

[sikander02]

Hi All,

Thanks for taking time and reading this. I am trying to put a macro in NPrinting excel template, it works fine when I preview it as ".xlsm" file but after publishing it and trying to open from email it throws error. I am trying to collapse the first column of pivotables using this macro,  Following  is the macro and error I am getting trying to open from email

Macroexcel error

Thanks,

Sikander

[marcus_sommer · Accepted solution]

Try it with .activate the worksheet instead of .select

- Marcus