How do I lock the formats of a sheet?

[Tmoske]

How can I make a sheet keep all the formating I set up. When other user's enter data, they can paste data but that will change my formats to what ever they are pasting already has.

Thanks,
Tmoske

 

[Sandeep Warrier]

You could ask them to do a Paste only values.

Before pasting the data, Right Click -> Paste Special -> Values and OK

 

[Tmoske]

Problem is that most user's that I have wouldn't have an idea of what I was talking about if I told them to do that. I know that's sad but, that's how it is. There should be a macro or something that could fix this issue for me.

Thanks,
Tmoske

 

[Sandeep Warrier]

I feel the easiest way to do this would be to create a macro that has your formattings recorded in it.

Let the users paste their data. Once they are thru pasting, just run your macro and it will apply your formatting.