jim may
Well-known Member
- Joined
- Jul 4, 2004
- Messages
- 7,486
What I've been trying to do might not be possible, but I'll ask anyway...
In my File on a Given Worksheet named "Main" - I clicked on View - New Window
So Now I have MyFileName.xlsm:1 and also (now, not before) MyFileName.xlsm:2.
Originally on my Main Sheet (Now +":1")- I had Sheet1, Sheet2 and Sheet3 and still in my
Now + ":2" window I have the same 3 Sheets, No Surprises so far...
MY Question..
In my ":1" Window Can I hide Sheet1 and Sheet3 - So that ONLY Sheet2 is Showing?
AND ALSO
In my ":2" Window Can I hide Sheet1 and Sheet2 - So that ONLY Sheet3 is Showing?



I'm trying to do this ALL in Code.
Thanks in advance.
Jim
In my File on a Given Worksheet named "Main" - I clicked on View - New Window
So Now I have MyFileName.xlsm:1 and also (now, not before) MyFileName.xlsm:2.
Originally on my Main Sheet (Now +":1")- I had Sheet1, Sheet2 and Sheet3 and still in my
Now + ":2" window I have the same 3 Sheets, No Surprises so far...
MY Question..
In my ":1" Window Can I hide Sheet1 and Sheet3 - So that ONLY Sheet2 is Showing?
AND ALSO
In my ":2" Window Can I hide Sheet1 and Sheet2 - So that ONLY Sheet3 is Showing?



I'm trying to do this ALL in Code.
Thanks in advance.
Jim
Last edited: