Page 1 of 1

Sheet Visible

Posted: Wed Sep 23, 2015 9:07 am
by mdonath
I would like to know how I can determine whether an Excel sheet is visible or hidden.
Could not find a property or function of TXLSWorksheet which gives me this information.

Thanks in advance.

Re: Sheet Visible

Posted: Wed Sep 23, 2015 12:07 pm
by mdonath
Meanwhile I found it.

TXLSWorksheet.Visibility

Unfortunately the value of 'Visibility' is always 'x12vVisible' after calling 'Read'.
What is to be done to get the correct value of 'Visibility'?