ExcelBanter - how do I link to hidden worksheets in excel?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - how do I link to hidden worksheets in excel? (https://www.excelbanter.com/excel-discussion-misc-queries/120414-how-do-i-link-hidden-worksheets-excel.html)

Jon

how do I link to hidden worksheets in excel?

Gord Dibben

how do I link to hidden worksheets in excel?

=Sheet1!A1

Same as if it was visible.

Gord Dibben MS Excel MVP

On Tue, 28 Nov 2006 09:44:01 -0800, Jon wrote:

Jon

how do I link to hidden worksheets in excel?

I want it to automatically switch to show the whole worksheet when you click
on the link, I can not get it to do that if I have the worksheet hidden.

"Gord Dibben" wrote:

=Sheet1!A1

Same as if it was visible.

Gord Dibben MS Excel MVP

On Tue, 28 Nov 2006 09:44:01 -0800, Jon wrote:

All times are GMT +1. The time now is 07:33 AM.