Hide/Unhide Sheet Based on Cell Value

[pamacme]

Hi,

I have a multi-sheet workbook with data feeding throughout the workbook. I have two project managers, Jim and Rosemary both very particular and "have" to have their columns and rows set up in a particular way. I set up a drop down on the cover page (General Status) with Jim and Rosemary as the two selections. When the drop down is set to "Rosemary" I need the Rosemary sheet visible and the "Jim" sheet hidden and when "Jim" is selected in the drop down I need the Jim Sheet visible and the Rosemary Sheet Hidden.

All I have been able to do is hide/unhide Rosemary But Jim's Sheet never goes away. I have included the workbook. FYI, Rosemary uses Acquisition Simple and Jim uses Acquisition Enter

Please Login or Register  to view this content.

Thanks in advance

[Artik]

Please edit your first post and put the quoted code in CODE tags (select the code content and use the [#] icon). This is a requirement of this forum.

If "Rosemary" is selected in H4, sheet "A. Simple" will be visible, when "Jim" is selected, sheet "A. Enter". In all other cases (a different user or an empty cell), both sheets will be hidden.

Please Login or Register  to view this content.

Artik

[pamacme]

Thank you for the quick reply. First, hopefully I made the changes regarding the CODE tags.
Second, I tried the code you provided and I don't seem to get it to work. I put it in the General Status Object. I also tried putting it in a Module and neither worked.
Any suggestions, or was I supposed to edit something?
Thank you