Forcing Match Destination Formatting

[Lilii]

Hi all,

I'm very new to Excel VBA so please bear with me.

I'm currently trying to force users to paste only so that it matches the destination formatting.

I've seen the following posts but it doesn't work for my situation:

• Allow user to only paste values, not formats
• Best way to force a Paste Values only
• Force Paste Special Values
• VBA - Restrict Users To Paste As Values Only

The cells where you can copy are the only Unlocked cells of my spreadsheet, knowing that the sheet would ideally be protected once my work is done.

I've also tried to see how excel is actually coding the paste matching destination formatting using the record macro button, and it gave me this:

    ActiveSheet.PasteSpecial Format:="HTML", Link:=False, DisplayAsIcon:= _
        False, NoHTMLFormatting:=True

Can someone please help me find a work around, I've been at it for hours and still can't get it to work.

Thanks a lot for your help!

Lili

 

[Lilii]

Hi James,

I'm so sorry, the solution (that I misread when I read your first message) you've offered works like a treat, thanks a lot!

Mumps, sorry if that wasn't clear but D11 was already unlocked.

Thanks a lot for your help, my issue is officially solved!

 

[James006]

You are welcome