If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
unlocking multiple worksheets
I would like to be able to unlock multiple worksheets
withing a workbook. I have a workbook compiled using copied worksheets from a number of workbooks. There are about 150 sheets, which are all locked and have the same password. Is it possible to globally unlock them? Your assistace would be appreciated. Regards Peter L. |
#2
|
|||
|
|||
Hi
use some code like dim unlock_all() dim wks as worksheet on error resume next for eack wks in worksheets wks.unprotect password:="your password" next on error goto 0 end sub -- Regards Frank Kabel Frankfurt, Germany "Peter Loveridge" schrieb im Newsbeitrag ... I would like to be able to unlock multiple worksheets withing a workbook. I have a workbook compiled using copied worksheets from a number of workbooks. There are about 150 sheets, which are all locked and have the same password. Is it possible to globally unlock them? Your assistace would be appreciated. Regards Peter L. |
#3
|
|||
|
|||
Frank
Thanks very much for your response. I will try it as soon as I get a break, and post again. Regards Peter Sydney Australia -----Original Message----- Hi use some code like dim unlock_all() dim wks as worksheet on error resume next for eack wks in worksheets wks.unprotect password:="your password" next on error goto 0 end sub -- Regards Frank Kabel Frankfurt, Germany "Peter Loveridge" schrieb im Newsbeitrag ... I would like to be able to unlock multiple worksheets withing a workbook. I have a workbook compiled using copied worksheets from a number of workbooks. There are about 150 sheets, which are all locked and have the same password. Is it possible to globally unlock them? Your assistace would be appreciated. Regards Peter L. . |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Setting paper source for multiple worksheets | Randy | Worksheet Functions | 2 | February 18th, 2004 08:36 PM |
Exporting multiple worksheets to one .CSV | Alan Cocks | Worksheet Functions | 1 | November 13th, 2003 10:56 AM |