Macro to show & hide rows based if cell B4 equals to "WEEKLY"

[ricdamiani]

Hi there, can you please help me with the below?

Macro to hide rows from 4 to 17 from the tab "Income", if cell B1 in the "Income" tab equals to "WEEKLY".
If B1 different than "WEEKLY", show rows 4 to 17.

Thanks

[jindon]

Do you mean like this?
To Income sheet code module

Please Login or Register  to view this content.

[ricdamiani]

I'm getting the error message below because the "Income" tab is protect.
Any way to run it with the tab protected?

"Run-time 1004", "Unable to set the hidden property of the range class".

[jindon]

Please Login or Register  to view this content.

[ricdamiani]

The above works if the tab is protected without password, but if it has password it asks for a password.
How can I fix the macro above if the tab has a password?

Cheers

[jindon]

The add password.

Please Login or Register  to view this content.

[ricdamiani]

Hi all,

I'm reviewing this macro, and I kindly ask if someone can help me to add to jindon's macro (see last post) the logic below:
- if B1 does not equal to "WEEKLY", hide rows 56 to 85 in the "Summary" tab

Cheers,

[ricdamiani]

Hi all,

Can someone please help me with the above?

Thanks,

[ricdamiani]

Hi there,

Is anyone able to help with that?

Cheers

[ricdamiani]

Sorry for being annoying, but anyone able to help please?

Thank you.

[ricdamiani]

Hi there,

Can someone help today please?

Thanks

[xladept]

Maybe if you add this line under the other hide line:

Please Login or Register  to view this content.

* If that sheet is also protected, you'll need to unprotect it..........

[ricdamiani]

Thanks xladept, but it didn't work.

Perhaps because I have the macro in the "Income" sheet code module? See jindon's first post.

Cheers

[xladept]

It definitely works - this is the code I ran on the unprotected sheet:

Please Login or Register  to view this content.

[ricdamiani]

Thanks xladept, but I can't get it to work if the Summary tab is protected.
Is the macro below correct?

Please Login or Register  to view this content.

[xladept]

The problem is - how are you going to enter WEEKLY in the Protected Sheet?

The code unprotects after you vainly entered it and then reprotects before you can try again.

You'll have to unprotect the sheet at the outset or nothing can be done

The macro is OK except for the protection code.

[ricdamiani]

The problem is - how are you going to enter WEEKLY in the Protected Sheet?

Not sure if I understood correctly, but jindon's original code works very well with the protected sheet:

Please Login or Register  to view this content.

But doesn't work well if I add the line you suggested:

Please Login or Register  to view this content.

In the debug mode, your line is highlighted and the Summary tab is not unprotected.

Isn't the error related to the fact that the macro is in the Income sheet code module?

[xladept]

Unprotect the summary sheet too:

Please Login or Register  to view this content.

[ricdamiani]

That in fact works, but just one last questions: when the macro is running, you can see in a fraction of a second it going to the Summary tab and going back to the Income tab.
Is there a way to avoid that? I mean, this stuff happening in the blink of an eye looks strange for who doesn't know the background of the macro. Ideally it would happen in the background and it wouldn't show switching tabs.

Thanks mate!

[xladept]

You must be really astute - I can't see anything at all when I run it, but I don't know why it would flash the summary tab Have you got other code working at the same time???

[Jamesera27]

Use the Application.ScreenUpdating property in excel

[ricdamiani]

You must be really astute - I can't see anything at all when I run it, but I don't know why it would flash the summary tab Have you got other code working at the same time???

It is actually pretty noticeable, perhaps if you have a lot of data like I do you can see it very well. But is still a blink of an eye.
No, nothing else running with this macro.
Is there anything can be done about it? Our the user will just need to deal with it?

Use the Application.ScreenUpdating property in excel

Sorry mate, can you please give me more information? How can I use that?

[xladept]

All I can think of is; maybe your display options are causing the flicker