Hiding Formula In Cell

[Front]

I am having issue with my table expanding when I protect my sheet. So as a work around I am using VBA to unprotect and then protect when a new entry is added. This works, but it breaks other functions on the table. So I am wondering if there is a way to have the sheet unprotected normally, then if someone tries to click on a cell that has a formula in it, the VBA would automatically protect the sheet. Then if another cell is clicked on it would unprotect it. Is something like that possible? That way I would not lose the functions I need.

 

[johnnyL]

@Front unless you provide an example of where your formulas are I don't think your quest will be achieved. We can't guess @ what you are dealing with.

I am thinking maybe a Worksheet_SelectionChange might work for you but without knowledge of where your formulas are, it is kind of difficult to offer some code.

 

[johnnyL]

Another problem I see is if you are inserting/deleting lines, that will fubar this type of approach.

 

[johnnyL]

I think I might have a solution, but like I mentioned previously, we need to know where the formulas are.

 

[johnnyL]

@Front, I am still waiting to here where the formulas are located.

I think I have code that protects the formulas, but I need to know where those formulas (Address ranges) are located in order to hide them. Are they all in a column or columns, maybe all in a row or rows? Maybe post an example with xl2BB?