Copy / Pasting ONLY value. Paste format NOT allowed

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

AA Arens - 25 Nov 2006 12:24 GMT

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

Reply to this Message

Jon von der Heyden - 25 Nov 2006 13:19 GMT

Bart,

See hatmans final post in this thread
http://www.mrexcel.com/board2/viewtopic.php?t=239997&highlight=copy

Regards

Jon von der Heyde

--
Jon von der Heyde

Posted from - http://www.officehelp.i

Reply to this Message

AA Arens - 26 Nov 2006 01:48 GMT

Bedankt, thanks, Jon It works.

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

Bart

On Nov 25, 8:19 pm, Jon von der Heyden
<Jon.von.der.Heyden.2ht...@NoSpamPleaze.com> wrote:

> Bart,
>
[quoted text clipped - 11 lines]
>
> Posted from -http://www.officehelp.in

Reply to this Message

jon_vonderheyden@yahoo.co.uk - 26 Nov 2006 09:45 GMT

Alsjeblieft, pleasure :-)

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

Regards
Jon

> Bedankt, thanks, Jon It works.
>
[quoted text clipped - 19 lines]
> >
> > Posted from -http://www.officehelp.in

Reply to this Message

Gord Dibben - 26 Nov 2006 17:22 GMT

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

>Alsjeblieft, pleasure :-)
>
[quoted text clipped - 27 lines]
>> >
>> > Posted from -http://www.officehelp.in

Reply to this Message

Jon von der Heyden - 26 Nov 2006 20:19 GMT

Indeed - thanks for the correction

--
Jon von der Heyde

Posted from - http://www.officehelp.i

Reply to this Message

Rate this thread: