protect layout / copy past with predifined lay-out settings

APOC [T.I.M.]

Board Regular
Joined
Jun 28, 2007
Messages
132
is there a simple way to "protect" the lay out of my worksheet in someway ???
I mean when I copy paste some info/text in my worksheet it's alway pasted in the default excel layout setting (arial 10) at least nearly all the time.

could I paste text by default with these settings?
Arrial Narrow 8 in the default (predifined) cell collor and no underline?
I guess I should use some vba code?
(and perhaps I can use this settings by default for all text in my worksheet by default?)
I did search but there are a lot and I mean a whole lot of topics but I still haven't found one which does what I want/need.

with kind regards
 

Some videos you may like

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.

APOC [T.I.M.]

Board Regular
Joined
Jun 28, 2007
Messages
132
ahahaaa, there it was/is, GREAT thank you...

can I "protect" copy-paste function from using it's own lay-out?
 

APOC [T.I.M.]

Board Regular
Joined
Jun 28, 2007
Messages
132

ADVERTISEMENT

by the way...

Only one weird thing is that when I change the default my column size also changes? weird and I don't wan't it to...
Changing the hyperling works pretty fine, though.
 

APOC [T.I.M.]

Board Regular
Joined
Jun 28, 2007
Messages
132

ADVERTISEMENT

ah okay,

can't I some how use vba to capture the past procedure?
ie. Selection.Paste and "mount" someway or another some Format/FormatSurrounding to it?
 

APOC [T.I.M.]

Board Regular
Joined
Jun 28, 2007
Messages
132
"can't I some how use vba to capture the past procedure?"
I mean ,,paste'' => can't I somehow use vba to capture the paste procedure?
 

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
You could try this in the module for the Worksheet:

Code:
Private Sub Worksheet_Change(ByVal Target As Range)
    Target.Style = "Normal"
End Sub
 

Watch MrExcel Video

Forum statistics

Threads
1,123,156
Messages
5,600,040
Members
414,357
Latest member
Gemma_R

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top