How to get the hidden-state of a worksheet ?
Posted: Wed Feb 19, 2014 11:47 am
How to get the hidden-state of a worksheet of a file just read?
with best regards
LuBo
with best regards
LuBo
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
...