Show sheet based on cell value

[tigergutt]

All,

I have spent the day looking for a macro to help me, but every single one i found doesn't work in my sheet.

I have a request sheet that wither will be a MR, MB or MT. Cell P4 in sheet3 has the following statement: =IF(Q4=2;"MR";IF(Q4=3;"MB";IF(Q4=4;"MT";"")))
(it was not originally made by me, so there are many people who have made their mark on this over the years)

So when cell P4 states "MB" i would like to unhide sheet8, else i want this sheet hidden.

Any takers? Do i need to upload an example (i can't use the actual sheet as it is company procedures), is so it would take some time to create one...

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[tigergutt]

Thanks for your reply John,
Do i need to activate anything, crate a button? Doesn't change my sheets unless i manually run the macro. is there a way for it to monitor cell P4?
(for some reason (8) did not work, but is Ok now when renamed to sheet name)

[JOHN H. DAVIS]

I don't think you can get it too monitor P4 (a formula) with event code. However based on your formula you can use this event code which monitors Q4 where the value that Generates "MB".

Please Login or Register  to view this content.

Sheets(8) is the index not the name. Same as Sheet8.

[tigergutt]

I appreciate your time John, I'm just not good enough with vba to get this running.

I will just leave it and it will be visible (not a problem, just nice to have it hidden when not needed.)

Cheers!

[JOHN H. DAVIS]

On Sheet 3. Right click on the mouse > Select View Code. A dropdown will appear. Left side choose Worksheet. Right side choose Change. Copy and paste the code provided there.