Ggalla1779 wrote:

How do I trap or stop user from clicking top left ...ie all cells

As it causes error on worksheet and stops all macros/ code running

Error message Application-defined or object-defined error (1004)

You're solving the wrong problem. Rather than prevent the users from
selecting everything, why not try to figure out what's causing the error in
the first place?

--
I've come to realize tonight, my friend, the end of time is not so far away.
We cannot pray to save our lives.