Skip to main content
Announcements
See why Qlik was named a Leader in the 2024 Gartner® Magic Quadrant™ for Data Integration Tools for the ninth year in a row: Get the report
cancel
Showing results for 
Search instead for 
Did you mean: 
sikander02
Contributor III
Contributor III

NPrinting Excel Macro error

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

MacroMacroexcel errorexcel error

Thanks,

Sikander

Labels (1)
1 Solution

Accepted Solutions
marcus_sommer

Try it with .activate the worksheet instead of .select

- Marcus

View solution in original post

1 Reply
marcus_sommer

Try it with .activate the worksheet instead of .select

- Marcus