: Opened a new wkbk
: dragged sheet 3 tab before sheet 2
: Went into the VBA Editor
:
: The codenames and names are now
:
: Sheet1 (Sheet1)
: Sheet2 (Sheet3)
: Sheet3 (Sheet2)
:
: It looks to me as though the codenames have changed.
When I do the same thing, I get this in the Project
Explorer window. I am running Excel 2002 SP3.
Sheet1 (Sheet1)
Sheet2 (Sheet2)
Sheet3 (Sheet3)
ThisWorkBook