Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Turning =E13 to =$E$13 | Excel Worksheet Functions | |||
turning off automatic Help | Excel Discussion (Misc queries) | |||
Turning off a Toolbar | Excel Discussion (Misc queries) | |||
keeps turning off | Excel Worksheet Functions | |||
Turning #N/A to a zero...?? | Excel Discussion (Misc queries) |