If a user open a spreadsheet in a workbook pressing button
on a form with a proc like below:
.......
Set xlBook = xlApp.Workbooks.Open(strWorkbookName)
Set xlSheet = xlBook.Worksheets(strWorksheetName)
xlSheet.Activate

xlApp.Visible = True
......

The workbook with the strWorksheetName1 is still opened
(visible).

How could the user activate another strWorksheetName2
pressing the button again and without closing and
reopenning the workbook. (There are 100 sheets).

Thanks