This procedu Workbook_SheetSelectionChange
should be behind the ThisWorkbook.

If you changed the procedure name and it worked fine, I'm surprised--but happy
for you.

If you didn't change the procedure name, then I think you have more testing to
do.



Ken McLennan wrote:

G'day there keepITcool,

If your selected cell is not in the rosterblock..
What happens? It'll give you a messagebox AND navigate to row 6

Well, I got that bit right then. That's what I want it to do. The
Header Block contains at least 58 formulae that I want my users to keep
well away from. However, if I protect the sheet then for some strange
reason the scroll goes haywire and I can't select most of the cells.

This way my users can't access the formulae, and I don't have to
figure out why protect is strange.

To have these handlers work only on single cell selections, you'd
normally include a line to check that the user is just navigating,
not making a selection...

I'd not thought of that...

Make this your first line.

If Target.cells.count 1 then exit sub

OK. I gave that a try and, unfortunately, it made no difference at
all.

However, I just realised that I may have the code in the wrong
place. Hang on for a minute...

OK, that seems to work fine. I've now moved the code from the
ThisWorkBook area to the codepage for the sheet it's supposed to work
on. Don't ask me why I had it in ThisWorkBook to start with. It was only
ever supposed to work on the first sheet and so should have been there
from the start.

Thanks very much for your help, keepITcool. Much appreciated.

--
Ken McLennan
Qld, Australia

--

Dave Peterson