vba - Excel unhide sheet by codename -

i use userform command buttons unhides veryhidden sheets , selects them sheet's codename can make edits sheet , hide them command button when done making changes sheet.

but when have (2) of workbooks different filenames open @ once error.

sub show_sheet()  blankoptionsheet.visible = -xlsheetvisible blankoptionsheet.select  end sub 

if userform in workbook not active @ time, code fail because can't select worksheet not in activeworkbook. should activate sheet instead of selecting it:

sub show_sheet()      blankoptionsheet.visible = -xlsheetvisible     blankoptionsheet.activate  end sub