Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
It is possible to use a macro for hide or display a sheet with conditional expression?
Thanks
Master
If you right hand click and go to the sheet properties.. Then layout.. you can set your condition for being able to view the sheet.
Thanks but if I use the sheet properties and then I change the selection by macro it seems tio lose the conditional expression.
For this reason I wan to tom tray to defibne the expression for conditional display by using a Imacro.
I've found this example
set mysheet=ActiveDocument.ActiveSheet
set sp=mysheet.GetProperties
sp.ShowAlways = false
sp.ShowExpression = "sum(Sales)>4000"
mysheet.SetProperties sp
but it don't work in my version.