prevent pasting to more than one row

Hi folks, I've hit a bit of a wall and can't find a solution to the following. . . I have a shared workbook, in excel 2007. The workbook contains a list of pupils' names, along with the name of the class that they are enrolled in. Users ...

Message posted on the May 13th, 2011 - 10:31 AM ET

Mocana Announces Mobile App Protection (MAP) for Android

MAP Works With Your MDM, to Make Mobile Apps “Self-Defending”, Gives the Enterprise Fine-Grained Control Over Individual App Security.

Press published on the October 18th, 2011 - 6:00 AM ET

Preventing pasting except for Paste Values

Within this Discussion Group, I have searched for "restrict pasting" and "prevent pasting", but I have been unable to find a thread that solves my problem. I want to prevent users from pasting anything in a cell except for ...

Message posted on the August 27th, 2009 - 10:52 PM ET

Prevent copy and paste in one column

I am having trouble trying to prevent copying and pasting in one specific column. The code refers to the specific range, but yet it prevents copying and pasting on the whole worksheet. Option Explicit Private Sub Worksheet_SelectionChange(ByVal ...

Message posted on the April 30th, 2010 - 2:42 PM ET

Prevent Cut and Paste

Hello, I have designed a workbook containing many drop windows. Other people use this book. It contains 31 sheets (one for each day of the month). The issue I am having is, lots of users cut and paste the information from one row to the next or ...

Message posted on the February 17th, 2010 - 3:05 PM ET

How do I PREVENT text in emails from being different sizes and some bolded?

This happens - seemingly without rhyme or reason - while I am composing an email. Usually when cutting and pasting a line of text to a different part of the message. Then it is impossible to get all of the text back to the same size. Minor issue ...

Message posted on the May 18th, 2013 - 10:31 AM ET

Prevent paste from re-formatting cell

worksheet is protected and all cells except 4 are locked. Even though users are not able to change formatting of these cells directly, I just realized that pasting info into one of these cells changes the format (to that of the copied info) and ...

Message posted on the January 14th, 2009 - 11:46 AM ET

prevent new masters being pasted in?

Hi, Working in PPT 2007 on Windows XP. When copying slides from one presentation to another, I would like to prevent users from possibly pasting in any master slides from the source file as well. (This happens if they chose "Keep source ...

Message posted on the April 20th, 2010 - 11:39 AM ET

prevent font size change when pasting copied text

When working in powerpoint, I find that when I paste text from the buffer, its font is changed. How do I prevent that?

Message posted on the April 7th, 2010 - 8:46 PM ET

How to prevent Cut&Paste to change style and data validation on protected sheet

Hi I would like to prevent that pasting to unlocked cells on a protected sheet changes the data validation and style. Is this possible? Thanks, PC

Message posted on the March 22nd, 2010 - 8:50 AM ET

How to prevent Cut&Paste to change style and data validation on protected sheet

Hi I would like to prevent that pasting to unlocked cells on a protected sheet changes the data validation and style. Is this possible? Thanks, PC

Message posted on the March 22nd, 2010 - 8:17 AM ET

Prevent Copying of Excel Workbooks in 2000 and 2003.

Is there a way of preveting a user to copy an excel workbook to a different folder location? We have excel spreadsheets saved in our company network and the locations are the one safe source of information. These workbooks contain data which is ...

Message posted on the January 14th, 2010 - 10:17 AM ET

Prevent function errors caused by cutting & paste or drag & drop

I have assembled a function on a worksheet that references cells in the worksheet. The worksheet is a living document. Changes are often made by cutting and pasting or dragging and dropping a cell value from one place to another, which always ...

Message posted on the November 2nd, 2009 - 3:09 PM ET

retain custom date format "text" when pasting or reformatting data

I am having problems getting Excel to retain the formatting for a column. When I realize its reformatting my data into a default date format, if i change the format setting on the column/cell back to "text", it produces some type of ...

Message posted on the October 27th, 2009 - 2:01 PM ET