Hi,
For your macro problem, I'm assuming the code you have works well on
the active sheet (if not, let us know what is causing problems). IF so,
try putting your code into this macro & use a find & replace in VBE to
change any use of "activesheet" in your code to "ws":
Sub UnprotectClearReprotect()
Dim ws As Worksheet
For Each ws In ThisWorkbook.Worksheets
'enter your code here
Next ws
End Sub
MsgBox "all done :-)"
End Sub
For your sort issue, go to cell A1, [ctrl+shift+end] (this is not the
full row but should select all cells upto & including the last column
with info in them), [alt+d+s] (ie Data - Sort), click yes for your
header row, then select the sort options to get "sort based on last
name, then first name, then MI".
hth
Rob Brockett
NZ
Always learning & the best way to learn is to experience...
--
broro183
------------------------------------------------------------------------
broro183's Profile:
http://www.excelforum.com/member.php...o&userid=30068
View this thread:
http://www.excelforum.com/showthread...hreadid=526317