protection
 

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

protection
 

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


"Chi" wrote in message
...
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

protection
 

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 B" wrote:

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


"Chi" wrote in message
...
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

protection
 

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

"Paul B" wrote:

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


"Chi" wrote in message
...
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

protection
 

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


"Chi" wrote in message
...
Paul,
Thank you, I got it. It works !!!!

"Paul B" wrote:

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


"Chi" wrote in message
...
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

protection
 

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

"Paul B" wrote:

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


"Chi" wrote in message
...
Paul,
Thank you, I got it. It works !!!!

"Paul B" wrote:

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


"Chi" wrote in message
...
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

protection
 

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

"Chi" wrote in message
...
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

"Paul B" wrote:

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


"Chi" wrote in message
...
Paul,
Thank you, I got it. It works !!!!

"Paul B" wrote:

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


"Chi" wrote in message
...
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

protection
 

Yes. Right-click on a chart, select Location ..., and that will let you put
it on a different sheet.
--
David Biddulph

"Chi" wrote in message
...
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