Macro to hide sheets

jellybean1977 · Apr 16th 2019, 10:11am

Hi

Is there a way to have an On_Open macro that hides sheets of a report based on a TRUE/FALSE flag in a cell?

Thanks

J

laloune · Apr 16th 2019, 2:21pm

unfortunately there don't seem to be a method for that in the macro engine api:

knowledgebase.jedox.com/doc/2019_1/macro_engine/

If possible I would have expect something like worksheet->hide()

jellybean1977 · Apr 16th 2019, 3:21pm

Thanks anyway

Share