View Full Version : restricting copy paste so it won't copy formatting

11-20-2007, 05:23 AM
I'm looking for a way to restrict copy/paste so it will never copy the formatting in the workbook i'm using.

this is so the users of the document can copy, but cannot mess up the formatting. Itried this with protecting the sheet, but the unprotected cells will accept a copied format.

Does anyone know what I can do about this?

11-20-2007, 05:42 AM
You'll have to trapp the keys (using onkey) that are used to copy and paste, also the menu items and button items. Than you'll have to write your own copy and paste routines using ActiveCell.Copy andActivecell.PasteSpecial xlPasteValues

11-20-2007, 06:10 AM
Hmm, that requires figuring out beforehand what they will try to copy where?

Isn't there a general thing?

11-20-2007, 07:09 AM
Ah I understand what you try to explain:

disable the rightclick paste etc and then create new routines that do so. hmm