I am writing an menu driven application in which I want the user to only be
able to see one worksheet at a time. Each worksheet will have a unique
associated window with unique size and positioning.

Dim wrksht as worksheet



My goal is to have a sub of the form


sub UnhideSheetAndItsAssociatedWindow (sheet_)

ActiveWorkbook.Unprotect Password:="mypassword"

sheet_.visible = true

' all other sheets made invisible
' unhide window associated with sheet_
' hide all other windows

ActiveWorkbook.Protect Structu=True, Windows:=True, _
password:="mypassword"



end sub


My questions are

1) is it possible to define an object of type window
2) if so, how might one associate a desired window with a desired worksheet
3) How might one code the sub so that if it is passed a parameter which is a
worksheet, it will unhide this sheet and hide all other sheets, and it will
unhide the associated window and hide all other windows ?

-regards