Hi, although not new to Excel, I have come across a problem I am having
difficulty with.
I have 7 columns:
"A";"D";"F" are input Cols
"B";"C" are vlookup and 'locked and hidden' and when sheet is protected so
users cannot see or change the formulas.
"E";"G" are sum cols when data is input into "D" and "F"
I have found out with EXCEL2003 and WinXP how I can sort the data in col "A"
and consequently the vlookup cols change respectively, BUT, I cannot get the
sheet to also sort cols "D" and "F" at the same time. As it would if the
'sheet protection' was switched off.
Is there a way of doing this? would I have to try and write a macro or VB
Script to do it? and how would that overcome the protection.

Regards
Graham

Try recording a macro when you do it manually.

Turn off protection
sort your range
turn on protection



grim wrote:

Hi, although not new to Excel, I have come across a problem I am having
difficulty with.
I have 7 columns:
"A";"D";"F" are input Cols
"B";"C" are vlookup and 'locked and hidden' and when sheet is protected so
users cannot see or change the formulas.
"E";"G" are sum cols when data is input into "D" and "F"
I have found out with EXCEL2003 and WinXP how I can sort the data in col "A"
and consequently the vlookup cols change respectively, BUT, I cannot get the
sheet to also sort cols "D" and "F" at the same time. As it would if the
'sheet protection' was switched off.
Is there a way of doing this? would I have to try and write a macro or VB
Script to do it? and how would that overcome the protection.

Regards
Graham

--

Dave Peterson