VenturaFwy
New Member
- Joined
- Mar 1, 2010
- Messages
- 5
I have multiple Workbooks, each with VBA code, and I number the sheets sequentially in each workbook. But when I look at the objects in the VBA Project it appears that Excel is keeping a running sequential count of sheets across ALL of the workbooks!
For example, in a particular workbook I may have 30 sheets numbered 1 - 30. But in the Project View sheet number 23 appears as Sheet(948)23.
Why are two different sheet numbers shown and where did that first one come from? The large size of it, 948, looks like it is sequentially numbering ALL the sheets across ALL the workbooks, in addition to the sequential numbers I am applying within each workbook.
I would like to turn off that count across multiple workbooks.
Thx
For example, in a particular workbook I may have 30 sheets numbered 1 - 30. But in the Project View sheet number 23 appears as Sheet(948)23.
Why are two different sheet numbers shown and where did that first one come from? The large size of it, 948, looks like it is sequentially numbering ALL the sheets across ALL the workbooks, in addition to the sequential numbers I am applying within each workbook.
I would like to turn off that count across multiple workbooks.
Thx