Dear All,
I have a workbook with three worksheep. I want to hide all the sheets except sheet1. and then these hidden sheets should open with a click button. I tried a macro and it only unhide sheet 2 but not opening it for editing. I want when the button on sheet 1 pressed it should open the sheet 2 not onlty make it visible.and second press it shold close.Please help me.
Regards.
Last edited by SEHRA; 02-13-2011 at 01:28 PM.
Try this workbook
Amend the sheet names and shape name to suit your real workbook
Last edited by Marcol; 02-13-2011 at 11:28 AM. Reason: Removed unrelated macro from attachment
If you need any more information, please feel free to ask.
However,If this takes care of your needs, please select Thread Tools from menu above and set this topic to SOLVED. It helps everybody! ....
Also
اس کی مدد کرتا ہے اگر
شکریہ کہنے کے لئے سٹار کلک کریں
If you are satisfied by any members response to your problem please consider using the small Star icon bottom left of their post to show your appreciation.
Thanks a lot.
Regards,
Sehra
Last edited by SEHRA; 02-13-2011 at 01:26 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks