LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default Turning off Cut and Copy?

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Turning =E13 to =$E$13 Bishop Excel Worksheet Functions 3 February 4th 10 06:58 PM
turning off automatic Help childofthe1980s Excel Discussion (Misc queries) 0 February 7th 09 04:55 PM
Turning off a Toolbar Blondie Excel Discussion (Misc queries) 1 May 27th 08 06:03 PM
keeps turning off rio Excel Worksheet Functions 4 August 31st 07 02:08 AM
Turning #N/A to a zero...?? bigtim Excel Discussion (Misc queries) 5 July 26th 05 08:48 PM


All times are GMT +1. The time now is 04:52 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"