i have an excel with sheet1, worksheet1 and worksheet2 tabs. I have inserted a command button in sheet1 which will make a userform popup. the userform has tabs (tab1 and tab2). how to make a code so that the worksheet1 will show and be editable on userforms tab1 and worksheet2 on userforms tab2. because i would actualy like to hide the worksheet1 and worksheet2 tab so that all the editing will be done in the userform. please see attached excel. thank you in advance![]()
Bookmarks