Couple of questions

[David]

1)I have 30 workshts, how can I password protect all of
them at once (not the workbook)without having to selet
each one individually?
2)a1=30 (this value is entered by position)

B(column) is training hours for the day, C is the total
training hours so far and D is their percentage. I'm
using the formula[ sum((c1/a1)*100). No problem. The
problem is when I drag drop the formula from D1200. The
C value changes, however the A value changes as well. Eg
sum((c1/a1)*100), sum((c2/a2)*100), sum((c3/a3)*100)... I
need to keep A1 constant throughout.

3) In one column there are 5 answers of "Correct", 4
answers of "Incorrect" and 2 answers of "Unknown". How
can I can I sort the answers in order from most appeared
to least appeared as they happen?

I hope I asked these in a way you could understand.
Thank you for your time.

 

[Jonathan Rynd]

1)I have 30 workshts, how can I password protect all of
them at once (not the workbook)without having to selet
each one individually?

VBA.

Sub doit()
Dim w As Worksheet
For Each w In ActiveWorkbook.Worksheets
w.Protect "Password"
Next w
End Sub

 

[Steve]

Your formula should be:
sum((c$1/a$1)*100)