V
Vonner
Is there a way to create a macro that sorts a protected worksheet wher
some of the cells are locked without putting the protection password i
the macro?
I've created a workbook that is used for keeping track of basebal
stats. On one of the worksheets (that is protected) I have an are
where the user can enter the stats for there players but the playe
name and a few other columns are locked (un-editable). I'm trying t
create a macro to sort the stats based on the batting average, but i
order to keep everything lined up correctly I need to sort the unlocke
cells along with four columns of locked cells. I can't figure out i
that possible.
Like I said, I got it to work by adding code to unprotect the shee
before sorting, then protecting it again after the sort, but I had t
put the protection password in the code to do it. That defeats th
purpose of password protecting the sheet in the first place because an
can get the password by browsing the code.
Anyone have any ideas?
Thanks
some of the cells are locked without putting the protection password i
the macro?
I've created a workbook that is used for keeping track of basebal
stats. On one of the worksheets (that is protected) I have an are
where the user can enter the stats for there players but the playe
name and a few other columns are locked (un-editable). I'm trying t
create a macro to sort the stats based on the batting average, but i
order to keep everything lined up correctly I need to sort the unlocke
cells along with four columns of locked cells. I can't figure out i
that possible.
Like I said, I got it to work by adding code to unprotect the shee
before sorting, then protecting it again after the sort, but I had t
put the protection password in the code to do it. That defeats th
purpose of password protecting the sheet in the first place because an
can get the password by browsing the code.
Anyone have any ideas?
Thanks