I've been having a real (tho stupid) problem w getting Auto_Activate to work
with sheets in my Workbook.
I create a name within an active sheet (say Sheet1) called "Auto_Activate".
I refer the name to a procedure (say OnActivate) that I have written within
Sheet1.

I get the error MsgBox "Can't find OnActivate".

So I've additionally tried the following permutations:
- Put OnActivate in Module1, ThisWorkbook (in addition to Sheet1).
(and verified its existence in all three using object browser)
- Changed the syntax in "Refers to" box to try e.g.
Sheet1.OnActivate
Sheet1!OnActivate
- Renamed Sheet1 to "FirstSheet" and repeated above using
e.g. FirstSheet!OnActivate

I've tried to methodically try every permutation I can think of and no luck.
After trying for 5 hours, I'm giving up and asking for help.

Doesn't what I've described seem to be the right way to go?
[I knew I only had one brain cell left, but, till now, it seemed to be working
just fine.....]