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
 
Ad

Advertisements

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
 
Ad

Advertisements

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
 
You must log in or register to reply here.

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

Is it possible to make pasting not allowed? 12
allow user to paste in a protected worksheet without unprotect it 3
Only allow one user at a time 7
workbook protection to allow only commenting 1
Protect sheet but allow sorting only 4
Formulas in custom number formatting allowed? 1
only allow data entry to 2nd decimal 1
Only allow to insert comment in Excel File 1

Top