View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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.