Worksheets are referenced in expressions, how make the worksheets visible? Excel 2000

[L Mehl]

Hello --

A workbook I was given shows 2 worksheet tabs. Cells in each of these
worksheets reference 2 other worksheets, as in
(H33) ='cannot see worksheet1'!A4
I can't see these referenced worksheets.

I can't see that any worksheets are hidden;
Windows > Unhide is greyed out

When I click a worksheet tab and select Move or Copy, only the 2 visible
worksheet tabs are listed; the 2 hidden worksheets are not in the list.

There is no password on the project.

Can anyone tell me how to make these "hidden" worksheets visible?

Thanks for any help.

Larry Mehl
mehl_at_cyvest.com

 

[Frank Kabel]

Hi
you can do this in vBA setting the property to
xlSheetVeryHidden

 

[L Mehl]

Frank --

Thanks for that code.

A few minutes after posting this, I discovered

Format > Sheet > Unhide

The referenced sheets are now visible.

Thanks for listening.

Larry Mehl