Need to rewrite protect code so that it will work with a hidden sheet.

**mrgillus** · 08-25-2009, 12:00 PM

I need this code below to work in a macro on a hidden sheet.. FYI the sheet name is "Closed".

Please Login or Register  to view this content.

Maybe something like:?

Please Login or Register  to view this content.

Just a guess.

Thanks for the help!

**jseufert** · 08-28-2009, 10:59 AM

You can't make selections from hidden sheets, columns, rows or cells. You'll have to hide and unhide areas at appropriate times to accomplish what you want.

**shg** · 08-28-2009, 08:17 PM

No need to unhide sheets to operate on them. Try this:

Please Login or Register  to view this content.

Need to rewrite protect code so that it will work with a hidden sheet.

LinkBack

Thread Tools

Rate This Thread

Display

Need to rewrite protect code so that it will work with a hidden sheet.

Re: Need to rewrite protect code so that it will work with a hidden sheet.

Re: Need to rewrite protect code so that it will work with a hidden sheet.

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions