But...
VBA doesn't run when the sheet is in "edit" mode.
If the user has copied a range then application.cutcopymode will be = 1
Tim
--
Tim Williams
Palo Alto, CA
"Kevin" <Ke...@discussions.microsoft.com> wrote in message
news:D75CD370-A327-4968...@microsoft.com...
> Greetings! I am trying to figure out how to determine the worksheets edit
> mode in VBA. I am referring to the mode text that is displayed in the
lower
> left hand corner of the Excel window status bar. I'm sure that I'm just
> looking for the wrong term, but any help would be appreciated.
>
> Thanks!
> --
> Kevin
Thanks!
--
Kevin
--
Tim Williams
Palo Alto, CA
"Kevin" <Ke...@discussions.microsoft.com> wrote in message
news:73397978-9423-46EA...@microsoft.com...