Copy / Pasting ONLY value. Paste format NOT allowed

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
 
A

AA Arens

Bedankt, thanks, Jon It works.

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

Bart
 
J

jon_vonderheyden

Alsjeblieft, pleasure :)

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

Regards
Jon
 
G

Gord Dibben

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro that copies values from column A (from formula) to B (paste value) 1
Copy and paste the cell boarder only not the content 3
Is it possible to make pasting not allowed? 12
Excel 2007 Paste Special 3
Copy condtional formatting in XL2007 for Windows 1
format slow down excel 3
Dual monitors, dual excels 6
Copy of value from one sheet to another with matching column values 1

Top