Limit Selection to a single cell

this works except that when you activate the worksheet you always get the message regardless of how many cells are selected?
Why is this & is there a way to eliminate it?

Please Login or Register  to view this content.

The part you posted worked for me.. Maybe post more of your code, or a sample workbook if you want me to take a more indepth look. banks

found the cause

I have a Worksheet_Activate Event that calls a procedure to unhide all cells

we can consider this thread closed