Password protect sheet - modify code

**eXtremer** · 07-02-2013, 08:05 AM

Hello,

I want to use the code below but I need it to function on 3 sheets not only in one.

I tried: If Sh.Name = "Sheet1" And "Sheet2" And "Sheet3" Then, but it doesn't work, I don't think I'm doing right, if smb could help me with one.

Thank you.

Please Login or Register  to view this content.

**JosephP** · 07-02-2013, 08:35 AM

Please Login or Register  to view this content.

for instance

**eXtremer** · 07-02-2013, 08:43 AM

Thank you. Issue solved.
But the correct code is:

Please Login or Register  to view this content.

**JosephP** · 07-02-2013, 08:46 AM

yes-I apologize-I copied and pasted the first part and forgot to remove the extra Ifs

Password protect sheet - modify code

LinkBack

Thread Tools

Rate This Thread

Display

Password protect sheet - modify code

Re: Password protect sheet - modify code

Re: Password protect sheet - modify code

Re: Password protect sheet - modify code

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions