View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default multi tab selection prohibition

The only situation where this would fail is if the user selected multiple
sheets and then immediately made a change to the current activecell on the
activesheet - the event would not be triggered. You could couple this with
a check in the SheetChange event to check Activewindow.SelectedSheets.Count
1 then do an immediate

Application.Undo

Or just use that type of approach in SheetChange.

--
Regards,
Tom Ogilvy

"COM" wrote in message
...
May be the best solution possible, without going through and undoing each

change that was then applied to all selected pages.

See my response on yesterday's thread.