Sorting Protected Sheet
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 |
Sorting Protected Sheet
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 |
All times are GMT +1. The time now is 11:17 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com