Can anyone please help?
With the help of Phil’s Genius I now have a fully working user form that is activated by pressing a control button on 'sheet 1' the active sheet of my workbook. After making given selections within the user form a ‘create form’ control button is selected and the information magically appears in my template on ‘sheet 3’ and the user form disappears, thanks to the ‘hide’ command within the programme code! But, and this is my problem, the sheet view stays on sheet 1 and ideally, I need a small string of code to fit in after telling the form to hide which basically says ‘now show sheet 3’ as the active sheet!
Any ideas my friends??? Many Thanks
With the help of Phil’s Genius I now have a fully working user form that is activated by pressing a control button on 'sheet 1' the active sheet of my workbook. After making given selections within the user form a ‘create form’ control button is selected and the information magically appears in my template on ‘sheet 3’ and the user form disappears, thanks to the ‘hide’ command within the programme code! But, and this is my problem, the sheet view stays on sheet 1 and ideally, I need a small string of code to fit in after telling the form to hide which basically says ‘now show sheet 3’ as the active sheet!
Any ideas my friends??? Many Thanks
