Hi all,
Could somebody confirm whether or not Excel 97 supports the .EnableSelection property on a locked range, and allows the cells below it to remain unlocked?
I have a protected worksheet with a macro which allows the user to click on the locked row and paste the row information into a new row below the range that is locked. I am doing this in Excel 2003.
A lot of subsequent code depends on being able to tell the difference between locked and unlocked cells - the users will be using Excel 97 so I need to know ASAP if their spreadsheets will support this format as I read somewhere on the internet that it was not possible to apply the xlNoRestrictions property to EnableSelection for locked cells.
Feedback appreciated, thanks
Could somebody confirm whether or not Excel 97 supports the .EnableSelection property on a locked range, and allows the cells below it to remain unlocked?
I have a protected worksheet with a macro which allows the user to click on the locked row and paste the row information into a new row below the range that is locked. I am doing this in Excel 2003.
A lot of subsequent code depends on being able to tell the difference between locked and unlocked cells - the users will be using Excel 97 so I need to know ASAP if their spreadsheets will support this format as I read somewhere on the internet that it was not possible to apply the xlNoRestrictions property to EnableSelection for locked cells.
Feedback appreciated, thanks
