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.
|