Make merged cells in clipboard paste as unmerged?

I

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
 
I

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
 
I

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
 
Top