Make merged cells in clipboard paste as unmerged?

[Imbecill]

Hi all,

If a user copy merged cells from another sheet, I dont' want to allow it to
paste as that, but just paste as a textstring in the selected cell.

Anybody having a sub macro to share?

/Regards

 

[Frank Kabel]

Hi
use 'Edit - Paste Special - Values' for inserting your content

 

[Imbecill]

I'm sorry I wasn't specific - the users will not do as I tell them ... I
need maybe a Sub macro to hang on to an Application.OnKey "^v" witin the
worksheet_activate.

/Regards

 

[Imbecill]

I'm happy to announce that I solved it:

SHEET:
Privat Worksheet_Activate ()
Application.OnKey "^v", "FormulaPaste"
End Sub

MODULE1:
Sub FormulaPaste()
Application.EnableEvents = False
ActiveSheet.Select
With Selection
.PasteSpecial Paste:=xlPasteFormulas, Operation:=xlNone, _
SkipBlanks:=False, Transpose:=False
End With
Call FormatTemp
Application.EnableEvents = True
End Sub

(The Sub FormatTemp copy - pastespecial - "formats" from a template sheet
with the right colors, fonts etc. This ensures the sheet always have the
right format.

/Regards