Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.links
|
|||
|
|||
Multiple page entries
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. |
#2
Posted to microsoft.public.excel.links
|
|||
|
|||
Multiple page entries
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
set up a link that updates page one from all other page entries? | Excel Worksheet Functions | |||
Page Numbers | Excel Discussion (Misc queries) | |||
How do I print a one page spreadsheet multiple time, each with its own page number? | Excel Discussion (Misc queries) | |||
Continuous page numbers in workbook of multiple worksheets | Excel Discussion (Misc queries) | |||
adding a new page break to an existing page break | Excel Discussion (Misc queries) |