Copy / Pasting ONLY value. Paste format NOT allowed

  • Thread starter Thread starter AA Arens
  • Start date Start date
A

AA Arens

I know about locking and protecting a sheet. How to get a user with
minimal rights to copy and paste only the value and not the format?

You can compaire it with Paste Special > Values

Bart
Excel 2003
 
Bedankt, thanks, Jon It works.

How to ohave it applied to all sheets? Where to put the code?

Bart
 
Alsjeblieft, pleasure :-)

In the VBE (Alt+F11), the code needs to be aplied to each worksheet,
not in a module.

Regards
Jon
 
The code in question is Workbook_SheetChange event code and would be placed into
the Thisworkbook module.

The code operates on whichever sheet is active so not necessary to place it in
all sheet modules.


Gord Dibben MS Excel MVP
 
Back
Top