hi Emil,
you can use code like Norman posted it.
if the sheets are hidden on opening the workbook (Workbook_Open
event), you can press the SHIFT key while opening (via file/open in
Excel).
Excel doesn´t start code in Workbook_Open then.

bye
stefan

On 20 Mai, 09:36, emilh wrote:
Thanks stefan.

it's 'xlSheetVeryHidden'

it seems that the only way is change the code each time i want to access the
data in those sheets?

--
Emil