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
 

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.
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.
 
Upvote 0
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?
 
Upvote 0
"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?
 
Upvote 0
You could try this in the module for the Worksheet:

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

Forum statistics

Threads
1,213,511
Messages
6,114,054
Members
448,543
Latest member
MartinLarkin

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
Back
Top