Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Sheet Protection

Status
Not open for further replies.
samato

samato

Technical User
Apr 26, 2003
37
US
Excel 2000 - If I grab a group of sheets, can I protect them all without having to protect each one?
 
Sort by date Sort by votes

Protect only seems to apply to a sheet and not to a collection of sheets so looks like the next best thing is:

Dim sh As Worksheet
For Each sh In Worksheets(Array("Sheet1", "Sheet3"))
sh.Protect
Next sh
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

remeng
  • Locked
  • Question
Delete dynamic table rows without removing password protection
Replies
7
Views
635
remeng
remeng
NewbieMacro
  • Locked
  • Question
Hello, I have a sheet named "Fin
Replies
2
Views
250
NewbieMacro
NewbieMacro
renigar
  • Locked
  • Question
Fishing for Ideas on sorting sheets in workbook
Replies
5
Views
531
SkipVought
S
kapok1
  • Locked
  • Question
add all the files under the same folder including the subfolder, all sheets in worbook included
Replies
2
Views
331
kapok1
kapok1
rajavj
  • Locked
  • Question
select only some sheets from a workbook through vba code so that reports can be got from those sheet
2
Replies
20
Views
534
SkipVought
S

Part and Inventory Search

Sponsor

Back
Top