protection

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I have a workbook that has many worksheets. All worksheets are protected
with the same password. Is there a way that I can unprotect them all at once
instead of unprotect each sheet at per time?
Please help.

Thanks
Chi
 
Chi, you can with a macro

Sub Unprotect_All_Sheets()
Dim ws As Worksheet
For Each ws In ThisWorkbook.Worksheets
ws.Unprotect password:="123" 'change password here
Next ws
End Sub
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
 
Hi Paul,

I appreciate for your promptly response. However, Macro is new to me, so
please tell me where I put it in and how it works.

Thanks
Chi
 
Paul,
Thank you, I got it. It works !!!!

Paul B said:
Chi, you can with a macro

Sub Unprotect_All_Sheets()
Dim ws As Worksheet
For Each ws In ThisWorkbook.Worksheets
ws.Unprotect password:="123" 'change password here
Next ws
End Sub
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
Click to expand...
 
Chi,
you may also what to have a look here on Getting Started with Macros and
User Defined Functions

http://www.mvps.org/dmcritchie/excel/getstarted.htm
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
 
I have another question, please.

I have four charts. They are on Sheet 1, sheet 2, sheet 3 and sheet 4.
I would like to put all charts in one sheet. Is there a way I can make it
happen?

Thank you so much
Chi
 
Chi, right click on the chart and pick location, select as object in and
pick the sheet you want, do this for each chart
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
 
Yes. Right-click on a chart, select Location ..., and that will let you put
it on a different sheet.
 
Back
Top