Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Error when save as CSV with VBA password protection on | Excel Discussion (Misc queries) | |||
VBA code error with Protection turned on - help please | Excel Discussion (Misc queries) | |||
Illinois Personal Information Protection Act | Excel Worksheet Functions | |||
workbook protection | New Users to Excel | |||
protection on excel forms | Excel Worksheet Functions |