Macro Hiding Sheet Not Working as Planned

[gxm100]

Hi everyone - I'm trying to get a macro to hide a sheet in my workbook when a certain condition is met in a certain cell. In this case, when the cell (which I've named term) has the value "No Contract", I would like the sheet to hide itself.

What I have is working, but not immediately upon entering "No Contract". For some reason, I have to enter "No Contract" and then click on the cell again to get it to hide, but I want it to be an immediate response to entering that value. I'm not very experienced in macros so I'm not sure where I'm going wrong.

Here is what I've got - again the cell which I want to trigger this is called Term and the worksheet is called COMPASS:

Please Login or Register  to view this content.

Any advice would be greatly appreciated!

Thanks

[AliGW]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Click on Edit to open your thread, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

[gxm100]

Sorry about that - fixed now

[AliGW]

Thank you.

[Mumps1]

Try:

Please Login or Register  to view this content.

[gxm100]

Thanks @Mumps1! Any advice on how I could make it recognize variations of "No Contract" such as "no contract" and "No contract"?

Thanks!

[Mumps1]

Try:

Please Login or Register  to view this content.