VBA macro that hide and unhide column to respective rows based on first column value

Hi, I am in need of dire assistance. I have an excel sheet that has 5 columns and dynamic range of row.
Column A has Error Messages that can either start with ED*, O14*, and HL*.
Columns to be hidden dependent on Column A value is below

• 
  ED*- only column B and C hidden
  O14*- only column B, C, D hidden
  HL*- only column C and E hidden

However, I don't want the columns to be hidden just to a that particular cell in Column A, but to that row of that cell.
I attached a sample excel file.
sample.xlsx

I could be wrong but I don't think you can hide an individual cell like you could a column or row. You can hide its contents through formatting (ie. setting its format to ";;;"). With that being said I am not sure what you are wanting to accomplish. Do you want to hide you specified columns based on only 1 parameter? Do you just want to make the contents invisible? Please clarify.

I want to hide the specified columns to one parameter- the contents of Column A, but instead of the columns being hidden to just the column A cell I want the columns hidden to the row of that cell.

Yeah I believe its all or nothing when hiding columns. You could delete the cells in that row and shift the remaining ones to the left but I don't think you want to do that. What you want to do may not be possible.

Hmm. What do you suggest? In actuality there are 50 columns; but dependent on Column A's cell value the user may only need 8 or 10 columns. I don't want the user to input data in the wrong columns. So that's why I was trying to hide some of the columns.

It really depends on the flow of your spreadsheet. In other words what are the procecess the user does. If for example they only enter in new data then I would probably set up a userform to popluate what you need. If they are going back and changing data in already completed row then you could lock certain cells.

Thanks, I used the locking of cells. It is perfect. Thanks so much.