How to get the hidden-state of a worksheet ?

[LuBo]

How to get the hidden-state of a worksheet of a file just read?

with best regards
LuBo

[larsa]

Hello

Use

Code: Select all

if XLS.Manager.Workbook.Sheets[0].State = x12vHidden then
  ...

In the next update can you use:

Code: Select all

if XLS[0].Visibility = x12vHidden then
  ...