Toggle Macro Troubleshooting w/ Multiple Sheets

[hysterical.useless]

I have a simple toggle macro that hides/unhides portions of the sheet when activated. I am not using Excel's built-in toggle button for this; I am just using a standard button. To get the toggle functionality, I have several of these statements within the macro:

Please Login or Register  to view this content.

This works fine as long as the button and the named range are on the same sheet. However, I cannot get it to work if the range to hide/unhide is on a different sheet from where the button is located. I have tried this code, but it doesn't work:

Please Login or Register  to view this content.

What am I doing wrong?

[AlphaFrog]

Don't put brackets around the sheet name e.g.
Worksheets("Sheet1")

[hysterical.useless]

Sorry, I should have noted that I didn't use that sheet name; I put the brackets around it to represent a customized sheet name. In reality it's more like this on my sheet:

Please Login or Register  to view this content.

[shg]

This worked fine for me:

Please Login or Register  to view this content.

[hysterical.useless]

Hmmmm, not working for me. Here's what my macro looks like in full:

Please Login or Register  to view this content.

The first five named ranges - NamedRange1-5 - are all on the first sheet with the button. Those all work.

NamedRange6 is one the second sheet (here, "Another Sheet"). Adding the period before "Hidden" as you did in your code caused an error; removing the period allows the macro to work, but it doesn't activate NamedRange6 on the second sheet.

The last four named ranges - NamedRange7-10 - are ranges that should hide whenever the button is pushed, regardless of the state of the toggle. Interestingly, NamedRange10 is on the second sheet ("Another Sheet") and it works here.

[hysterical.useless]

I just adjusted the "With" section to this, but it's still not working:

Please Login or Register  to view this content.

[Fluff13]

Do you get any error messages?
Also is "NamedRange6" workbook, or sheet scope?

[hysterical.useless]

I am currently not getting any error messages, but NamedRange6 is not hiding/unhiding on the second sheet. All of my named ranges are workbook scope.

[Fluff13]

In that case there is no need to use the sheet name, you can simply use

Please Login or Register  to view this content.

[hysterical.useless]

Ok, I feel really dumb right now but I think I discovered the issue. NamedRange6 is included within the scope of NamedRange10, so even though it hides/unhides properly with this code it is immediately negated when this last line runs:

Please Login or Register  to view this content.

I'm sorry for all of the trouble, but I appreciate the help! I'll let you know if I have any further issues.

[hysterical.useless]

Speaking of which, is there a way to run VBA code line by line? I feel like I would have caught this error a lot sooner if I could have seen the code work properly until that last line negated everything.

[Fluff13]

Glad you figured it out.
If you put the cursor anywhere in the code you can use F8 to step through line by line.

[shg]

Speaking of which, is there a way to run VBA code line by line?

http://www.cpearson.com/excel/debuggingvba.aspx

[hysterical.useless]

Thanks! Much appreciated.