Disabling Selection of multiple worksheets
I don't think you can prevent it, but you can force the sheets to be
ungrouped by checking on every selection change
Private Sub Workbook_SheetSelectionChange( _
ByVal Sh As Object, ByVal Target As Range)
If ActiveWindow.SelectedSheets.Count 1 Then
ActiveSheet.Select
End If
End Sub
As with any macro solution, disabling macros disables the protection.
--
Regards,
Tom Ogilvy
"COM" wrote in message
...
An interesting idea, though it would then require more extensive
programming to make each desired tab available/visible for editing.
Certainly a fix, but not a good one in this scenario. Thank you though.
Still looking to disable the selection of multiple worksheets within a
workbook. Want to have all sheets available to be selected, but only
allowing selection of a single worksheet at any/all times.
|