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


On Nov 25, 8:19 pm, Jon von der Heyden
<Jon.von.der.Heyden.2ht...@NoSpamPleaze.com> wrote:
> Bart,
>
> See hatmans final post in this thread:http://www.mrexcel.com/board2/viewto...highlight=copy
>
> Regards
>
> Jon von der Heyden
>
> --
> Jon von der Heyden
> ------------------------------------------------------------------------
> Jon von der Heyden's Profile:http://www.officehelp.in/member.php?userid=4852
> View this thread:http://www.officehelp.in/showthread.php?t=1270238
>
> Posted from -http://www.officehelp.in

Alsjeblieft, pleasure :-)

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

Regards
Jon

AA Arens wrote:

> 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,
> >
> > See hatmans final post in this thread:http://www.mrexcel.com/board2/viewto...highlight=copy
> >
> > Regards
> >
> > Jon von der Heyden
> >
> > --
> > Jon von der Heyden
> > ------------------------------------------------------------------------
> > Jon von der Heyden's Profile:http://www.officehelp.in/member.php?userid=4852
> > View this thread:http://www.officehelp.in/showthread.php?t=1270238
> >
> > Posted from -http://www.officehelp.in

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


On 26 Nov 2006 01:45:16 -0800, (E-Mail Removed) wrote:

>Alsjeblieft, pleasure :-)
>
>In the VBE (Alt+F11), the code needs to be aplied to each worksheet,
>not in a module.
>
>Regards
>Jon
>
>AA Arens wrote:
>
>> 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,
>> >
>> > See hatmans final post in this thread http://www.mrexcel.com/board2/viewto...highlight=copy
>> >
>> > Regards
>> >
>> > Jon von der Heyden
>> >
>> > --
>> > Jon von der Heyden
>> > ------------------------------------------------------------------------
>> > Jon von der Heyden's Profile:http://www.officehelp.in/member.php?userid=4852
>> > View this thread:http://www.officehelp.in/showthread.php?t=1270238
>> >
>> > Posted from -http://www.officehelp.in