Typing text in a column undoing code that autohides other colums making them visible

Hi Guys,

I have attached a sample spreadsheet to illustrate my problem.

I have the spreadsheet set up so when the first person logs in the numbers 1234 automatically populate into a cell in a few sheets. This is then a trigger for certain columns to unhide. If someone else logs in these numbers do not populate therefore keeping the columns hidden. Works perfect.
However when logged in as user 1 & allcolumns are unhidden, I type anything in column "X" in sheet "Mort Figs" it undoes the 1234 and hides all the columns even though 1234 is still populated. This should not happen. I posted this a while back with no joy so hoping someone will be able to help.


Any help really appreciated.

Username: John
Password: Test

Hi alphafrog

Thank you for your response. My level is still quite basic regarding VBA. All I've done so far has been wih the help of this forum. If a date is typed in column x I want the date brought over to sheet Banc *** & Home Ins. So thats why there is a trigger for column x. However I did not want it hiding columns. Columns should only hide if cell AJ1 is cleared. Any suggestions as to what I should wrap the code in would be great. If you need anymore info please let me know

Thank you
Nitro

Hi AlphaFrog

I basically have this code at the end of every workbook so as the page protects everytime I save, close or open the workbook. (I'm sure there was an easier way of doing it)

Please Login or Register  to view this content.

I must have copied this code form earlier on in the Sheet code which included the bit in red. Once I delete this line the problem has stopped.

Please Login or Register  to view this content.

Thank you so much for your help and time.