Cell font and font size

excelledsoftware · #1 02-09-2014, 09:07 PM

One way you could do it is to have them paste just the text each time. I wrote this code a little bit ago for this purpose. It recognizes if the text they are pasting is from Excel or another source. you could assign this to button or autoshape and then they can just click that button rather than CTRL V or right click then paste.

Code:

Sub PasteText()
    On Error GoTo valueerror
    ActiveSheet.PasteSpecial Format:="Text", Link:=False, DisplayAsIcon:= _
        False
End
valueerror:
On Error GoTo clipboardempty
        Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
        :=False, Transpose:=False
    End
    
clipboardempty:
MsgBox "Nothing on clipboard to paste."
End
        
End Sub

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Word will not hold settings, such as font and size of font	Mary M	Word	1	10-12-2013 07:41 AM
Font Size	cjpga	Outlook	1	04-13-2013 06:45 AM
how change size font to inches size	kkepo	Word	4	08-28-2012 08:53 PM
Cursor size varies with font size	r_lewis@fuse.net	Word	0	07-20-2011 06:11 PM
Font Size	iflog	Outlook	1	11-30-2010 09:33 PM