Protecting Cell Format while pasting from another source

[arshad.99.ali]

Hi,

I want to protect a cell format where if I paste the data from other source format should not get change.

Ex: I am protecting A1 Cell format with Yellow color background, now I am copying the data from other source which contains Red color background and pasting in A1 Cell (which is format protected) now the target cell background get changed to Red.

I don't want to get change the format of the cell in any circumstances.

This problem is arising when I gave a standard template format to site officers, they are copy pasting the data from other files and it is effecting to template

Kindly advise on above

[perpectuals]

1. Select the Contents

2. Copy it.

3. Select Paste Special

4. Click "Values & Number Formats"

5. Click "OK".

Formats Won't get affected. Only the data will change.

Hi,

I want to protect a cell format where if I paste the data from other source format should not get change.

Ex: I am protecting A1 Cell format with Yellow color background, now I am copying the data from other source which contains Red color background and pasting in A1 Cell (which is format protected) now the target cell background get changed to Red.

I don't want to get change the format of the cell in any circumstances.

This problem is arising when I gave a standard template format to site officers, they are copy pasting the data from other files and it is effecting to template

Kindly advise on above

[arshad.99.ali]

Hi,
Thank you for your valuable advise, but I know above procedure to paste only values.

Concern is I have prepared a standard template for reporting system and it would be shared to all site supervisors.
they are copying the data from other files and pasting in report template hence it is effecting format in the template

I can not teach or show to them that how to paste only values as they were More than 100 number of supervisors should report

if you have any other way to paste the data without effecting any format then kindly let me know.

Thanks in advance for your help !!!!

[popipipo]

Make a VBA code how your standard template should look like.
Let this code automatically run (BeforeClose event) every time you close the file.

Take a look at this simple example
Copy H4:H6 in A4:A6 save the file and reopen.

[arshad.99.ali]

Thank you...

Above file solved my thread.

I will adjust the coding as per my requirements

[popipipo]

If you make a sheet with the standard layout and hide this sheet you can use a much shorter and i think faster code.