Prev: Your formuala also seems much simpler than mine.
Next: How do I disable the advanced printing features permanently?
From: Candice on 17 Dec 2009 08:54
Paul B:

Thank you. Your macro worked very, very well. Thank you again.

"Paul B" wrote:

> Indiana, you can use a macro like this,
>
> Sub protect_sheets()
>
> Dim ws As Worksheet
>
> For Each ws In ThisWorkbook.Worksheets
>
> ws.Protect password:="123"
>
> 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
>
>
> "Indiana born" <Indiana born(a)discussions.microsoft.com> wrote in message
> news:38EDFDC8-56DC-44E7-B2A9-4E49148F2FC7(a)microsoft.com...
> >I have spreadsheets with multiple tabs - I presently have to password
> >protect
> > each tab separately. I'm looking for a way to protect all tabs with one
> > password entry. i am not share the files, but others do view them and I
> > don't want changes made.
>
>
>
 | 
Pages: 1
Prev: Your formuala also seems much simpler than mine.
Next: How do I disable the advanced printing features permanently?