H
Hawkfan757
I have a spreadsheet that data will be inputted in columns A thru C. Columns
D thru F have formulas in them that I do not want to get messed up so I have
protected these cells. My problem is I want the user of this spreadsheet to
enter data into columns A thru C and then to sort the data, but the data
cannot be sorted since I have protected columns D thru F. My next thought was
that I could create a macro that would unprotect the cells, input the
password, sort the data, and then protect the cells again with the password I
have provided. However, I can not make this work unless I do not use a
password for the protected cells. Does anybody have any ideas for how I could
accomplish this? Your help is greatly appreciated.
D thru F have formulas in them that I do not want to get messed up so I have
protected these cells. My problem is I want the user of this spreadsheet to
enter data into columns A thru C and then to sort the data, but the data
cannot be sorted since I have protected columns D thru F. My next thought was
that I could create a macro that would unprotect the cells, input the
password, sort the data, and then protect the cells again with the password I
have provided. However, I can not make this work unless I do not use a
password for the protected cells. Does anybody have any ideas for how I could
accomplish this? Your help is greatly appreciated.