Sometimes we need to enforce users select a range on the current sheet, we don't want users to switch to another sheet.
Like select Rows to repeat at top in Excel:
Workaround
Hide other sheets when a dialog opens and unhide them when the dialog closes.