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
 

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

Top