I had a problem with a worksheet where the formulas were not recalclulating.
I essentially solved it by renaming my worksheet (to SummaryBak) and using a
new worksheet I named Summary. This morning, while changing the codename of
Summary, I noticed that, the worksheet SummaryBak was not showing up in the
VBE (in the window that lists the Projects, probably called Projects window.)
I did a little research on the
worksheet, for instance, I checked if it had
somehow become protected. Based on the options, it would seem it hasn't.
If I make that worksheet the active worksheet, and type, from the immediate
window, ? activesheet.name, it says SummaryBak. However, if I type ?
worksheet.codename, I get an error: Runtime error 1004, application defined
As far as I know, this isn't causing me any additional problems, but I can't
help wondering if it points to the original problem I was having with not
recalculating. If I weren't such a pack rat, I would have already deleted
this worksheet, as it has been replaced. However, if any one can shed some
light as to what would cause this, I would appreciate a response. Also, if
it is a ticking time bomb waiting to explode, please let me know and I will
delete post haste.