Thread
:
Unprotecting Sheets
View Single Post
#
5
Posted to microsoft.public.excel.newusers
Zee[_2_]
external usenet poster
Posts: 14
Unprotecting Sheets
Hi Galimi,
I tried pasting the code into the
VB
editor and the first line states an
error.
Thanks
"galimi" wrote:
Zee,
The following code should do it:
public sub unlock
for each sht in thisworkbook.sheets
sht.unprotect
next
end sub
--
http://www.ExcelHelp.us
Call me at
1-888-MY-ETHER ext. 01781474
"Zee" wrote:
Unfortunately I am not very familiar with VBA and therefore am not sure what
to enter into the editor to accomplish this.
"galimi" wrote:
Zee,
You could use VBA to cycle through all the sheets that are protected and
unprotect them that way. Don't think it is possible without code.
--
http://www.ExcelHelp.us
888-MY-ETHER ext. 01781474
"Zee" wrote:
Is it possible to unprotect all sheets in a workbook at the same time?
Reply With Quote
Zee[_2_]
View Public Profile
Find all posts by Zee[_2_]