Is there a way to create a macro that sorts a protected worksheet where
some of the cells are locked without putting the protection password in
the macro?

I've created a workbook that is used for keeping track of baseball
stats. On one of the worksheets (that is protected) I have an area
where the user can enter the stats for there players but the player
name and a few other columns are locked (un-editable). I'm trying to
create a macro to sort the stats based on the batting average, but in
order to keep everything lined up correctly I need to sort the unlocked
cells along with four columns of locked cells. I can't figure out if
that possible.

Like I said, I got it to work by adding code to unprotect the sheet
before sorting, then protecting it again after the sort, but I had to
put the protection password in the code to do it. That defeats the
purpose of password protecting the sheet in the first place because any
can get the password by browsing the code.

Anyone have any ideas?

Thanks.


--
Vonner
------------------------------------------------------------------------
Vonner's Profile: http://www.excelforum.com/member.php...o&userid=25283
View this thread: http://www.excelforum.com/showthread...hreadid=387735

Hi Vonner,

That defeats the
purpose of password protecting the sheet in the first place because any
can get the password by browsing the code.

Try locking and protecting the project:

Right- click the project in the VBE , select VBA Project Properties,
Protection Tab...

This will hide your code from casual users. Excel does not, however, provide
a secure environment and a determined user will readily be able to gain
access to your code. Such determination need not exceed suitable Google
search.

---
Regards,
Norman



"Vonner" wrote in
message ...

Is there a way to create a macro that sorts a protected worksheet where
some of the cells are locked without putting the protection password in
the macro?

I've created a workbook that is used for keeping track of baseball
stats. On one of the worksheets (that is protected) I have an area
where the user can enter the stats for there players but the player
name and a few other columns are locked (un-editable). I'm trying to
create a macro to sort the stats based on the batting average, but in
order to keep everything lined up correctly I need to sort the unlocked
cells along with four columns of locked cells. I can't figure out if
that possible.

Like I said, I got it to work by adding code to unprotect the sheet
before sorting, then protecting it again after the sort, but I had to
put the protection password in the code to do it. That defeats the
purpose of password protecting the sheet in the first place because any
can get the password by browsing the code.

Anyone have any ideas?

Thanks.


--
Vonner
------------------------------------------------------------------------
Vonner's Profile:
http://www.excelforum.com/member.php...o&userid=25283
View this thread: http://www.excelforum.com/showthread...hreadid=387735