Question about transferring data from Sheet 1 to Sheet 2

[Nesto14]

I created an excel file using Macro, where I input data into sheet one and click submit to send it to sheet 2. Now I need help protecting sheet 2 but for the data to still transfer from sheet 1 to sheet 2 while it's protected. Is this possible? Sorry I'm new to excel....

 

[mumps]

In the macro you use to send the data to Sheet2, put the following line at the beginning of the macro:

Sheets("Sheet2").Unprotect Password:="password"

and the following line at the end of the macro:

Sheets("Sheet2").Protect Password:="password"

Replace "password" with the actual password you are using.

 

[Nesto14]

Thank you very much, worked perfectly!!! What if I wanted to only protect Columns A-E in sheet 2 though?

 

[Nesto14]

In the macro you use to send the data to Sheet2, put the following line at the beginning of the macro:

Sheets("Sheet2").Unprotect Password:="password"

and the following line at the end of the macro:

Sheets("Sheet2").Protect Password:="password"

Replace "password" with the actual password you are using.

Thank you very much, worked perfectly!!! What if I wanted to only protect Columns A-E in sheet 2 though?

 

[mumps]

You would have to unlock all the cells starting from column F.

 

[Nesto14]

You would have to unlock all the cells starting from column F.

I unlocked all the cells from columns F & G but the macro seems to lock the entire sheet anyway....

 

[Nesto14]

You would have to unlock all the cells starting from column F.

I know what happened, I have it to enter the entire row from sheet 1 to sheet 2 so when the row gets submitted from sheet 1 to sheet 2 it locks that entire row. Can you use macro to only lock certain columns?

 

[Nesto14]

You would have to unlock all the cells starting from column F.

I figured it out, thank you very much for your help!!! This is exactly what I needed!

 

[mumps]

My pleasure.

 

[Nesto14]

My pleasure.

Ok one more thing sorry to bother you. So now I need the cells in columns F & G in sheet 2 to auto lock once info is entered into them so they can be protected as well. Can I do that?