Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is there a way to extract the show condition of the sheets in an application from a macro?
Thanks
I found this example in the API:
set mysheet=ActiveDocument.ActiveSheet
set sp=mysheet.GetProperties
sp.Show.Always = false
sp.Show.Expression.v = "sum(Sales)>4000"
mysheet.SetProperties sp
Hope this helps you
Hi Jonathan,
sure that should be possible if you can read the macro. Could you post or attach it?
Hi DataNibbler,
At the moment, I don't have a macro set up for this. I am trying to find the function that will return these conditions.
I found this example in the API:
set mysheet=ActiveDocument.ActiveSheet
set sp=mysheet.GetProperties
sp.Show.Always = false
sp.Show.Expression.v = "sum(Sales)>4000"
mysheet.SetProperties sp
Hope this helps you