How to show/hide excel worksheet using UserForm

Closed

akumarsahu Posts 2 Registration date Sunday June 8, 2014 Status Member Last seen June 8, 2014 - Jun 8, 2014 at 06:05 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jun 12, 2014 at 11:21 AM

Hello,

I have prepared one user form and given option button & submit button.

I have 4 worksheet. My queries is....

1. If I select Option 1 and click submit button then my Sheet 1 should visible likewise If I click on Option button 2 and then click submit button then my sheet no 2 should visible and sheet one will hide.

Please help me to proceed with this formulae

How to show/hide excel worksheet using UserForm
How to hide app store on ipad - Guide
Transfer data from one excel worksheet to another automatically - Guide
How to see hide story on instagram - Guide
Number to words in excel - Guide
How to hide downloaded videos on youtube - Guide

1 response

Answer 1 / 1

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jun 11, 2014 at 07:17 PM

on click of button you can trigger code to hide sheet and display sheet.

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
Jun 12, 2014 at 11:21 AM

Hoeray Riz is back! I thought we lost you!

Hopefully you are doing great.

Good to see you again.

Trowa

Subscribe To Our Newsletter!