Auto Hiding a column

[Nitro2481]

Hi Guys,

I have gotten help on this before and have the following formula in sheet 2

Sheet 2

Please Login or Register  to view this content.

And this formula in "THIS WORKBOOK"

Please Login or Register  to view this content.

What I want to do now is hide a few more columns in Sheet 2 only
I tried

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

But this is giving me an error.

Basically when I login a cell auto populates with 1234 this then shows the column. When I log out the cell automatically depopulates and the column disappears. However when someone else logs in the column does not appear.
The columns in Sheet 2 I'm looking tio hide are X,AM,AR,AW & BD
Any ideas?

Thanks Nitro

[LJMetzger]

Try:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Lewis

[Nitro2481]

Hello again Lewis

I am a little confused.Where are these codes to go?

I have put it in Sheet 2
End If

Please Login or Register  to view this content.

I added the red bit and I'm getting an error in the green bit

On the THIS WORKBOOK

Please Login or Register  to view this content.

I also added the red here. Not sure where to put your

Please Login or Register  to view this content.

The fact it has shide2 I was thinking it should go on the THISWORKBOOK page but not sure.

Thanks

[LJMetzger]

In ThisWorkbook, make sure you change BOTH lines below in red:

Please Login or Register  to view this content.

You can make similar changes for other columns.

Lewis

[Nitro2481]

Hi Lewis,

I've done what you have suggested and I'm no longer getting an error message. Do I not need to do anything on the sheet 2 code also as this is only calling for
x.

Please Login or Register  to view this content.

I tried

Please Login or Register  to view this content.

Sorry

[LJMetzger]

When you only have one item, your original code will work.

When you have more than one item you need to change the syntax to "X:X, AM:AM, ..." etc.
When you have more than one item you also must change the other code:

From:

Please Login or Register  to view this content.

To:

Please Login or Register  to view this content.

[Nitro2481]

Lewis,

You did it again. That worked. Thanks a mil

Nitro