Hi all
What I have is a worksheet that I want to hide, and when a user of the main sheet clicks a button I would like the hidden sheet to then be shown in a seperate window which is sized to that of the set area of the work space of that sheet.
I hope I'm makig sense here.
Plz help!
Last edited by famico78; 05-29-2009 at 06:55 AM. Reason: Now solved
Afternoon
you can use the following code to unhide hidden sheets
make sure you leave the quotations in
Please Login or Register to view this content.
but as far as your sized window goes i am not sure
you can also change the .visible = true to .visible = false to hide the sheet again
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks