Multiple page entries

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

DAVID SHAUBS - 01 Aug 2006 04:56 GMT

I've been using the same 88 page workbook for about 2 years, in the same
way. Today, when I entered any data, it was entered across all 88 pages, on
the same line that I originally entered it. Unfortunately, I didn't notice
it until I had already saved a few times. How do I stop Excel from doing
this. I did not make any changes other than entering data.

Reply to this Message

Bill Manville - 01 Aug 2006 08:21 GMT

You must have grouped the worksheets (e.g. by having the left-most one
selected and then shift-clicking the tab of the right-most one).
[Group] will show in the title bar when it is in this state.

You could put this code in the ThisWorkbook module to be warned as it
happens:

Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As
Range)
If ActiveWindow.SelectedSheets.Count > 1 And Sh.Name =
ActiveSheet.Name Then
MsgBox "You just made a change in group mode" & vbNewline & _
"it will affect other sheets; edit/undo if it was not inteded"
End If
End Sub

I hope you had a backup.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup

Reply to this Message