Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Macro that sorts
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. |
#2
|
|||
|
|||
Hi
you could unprotect with activesheet.unprotect password:="your_password" -- Regards Frank Kabel Frankfurt, Germany "Hawkfan757" schrieb im Newsbeitrag ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Moving down one row in a macro | New Users to Excel | |||
Executing macro for all worksheet from a different worksheet | New Users to Excel | |||
Macro and If Statement | Excel Discussion (Misc queries) | |||
Macro Formula revision? | Excel Worksheet Functions | |||
Macro for multiple charts | Excel Worksheet Functions |