Hi,

I have a range in a worksheet that I do not want users to cut or copy in
when they are in that sheet. The working cells in this worksheet are linked
to another worksheet and it changes their formulas when cut/copy is used.

There is still a need to edit this page as it is basically a list of teams
and names. Team members change from one team to another from time to time.
The preference is that the team members name is deleted and re-typed not cut
or copied and placed in the new team.

I'm not sure where to start but I thought OnAction or somehow when the mouse
moves over the working range that it prevents cut or copy from being used in
that worksheet. I have told users not to use cut or copy, but they forget.
It's a simple workbook that helps me with my rosters.

If you can assist in any way it would be greatly appreciated.

Regards,

Wazza McG

Don't know if this helps but have you though of protecting
the sheet and locking the cells that you don't want people
to change?
-----Original Message-----
Hi,

I have a range in a worksheet that I do not want users to
cut or copy in
when they are in that sheet. The working cells in this
worksheet are linked
to another worksheet and it changes their formulas when
cut/copy is used.

There is still a need to edit this page as it is
basically a list of teams
and names. Team members change from one team to another
from time to time.
The preference is that the team members name is deleted
and re-typed not cut
or copied and placed in the new team.

I'm not sure where to start but I thought OnAction or
somehow when the mouse
moves over the working range that it prevents cut or copy
from being used in
that worksheet. I have told users not to use cut or
copy, but they forget.
It's a simple workbook that helps me with my rosters.

If you can assist in any way it would be greatly
appreciated.

Regards,

Wazza McG


.

Yes I have, however, this is not suitable as they have to edit the cell in
the range to change the names of the team members. Once the cell is
unprotected they would be able to cut and copy. Thanks anyway.

Wazza McG