This is a multiple part question.

1. I have formulas in my worksheet that I need to protect. These formulas are all on the same column. FYI the have 4 columns of formulas. I do not want people to be able to tamper with these columns at all. I only want the formula answer to appear in the cells.

How do I resolve this issue?

2. I have 4 hidden columns in my worksheet column 'c' acts as a start point for a code that I have written to insert a column before column 'd' this allows me to perform one of my formulas that adds everything between column 'c' and 'd'. Column 'e' and 'f' perform the same actions as 'c' and 'd'. I want to hide and protect columns 'c thru f' but still allow my code to be able to insert columns in there proper places and allow for my formulas to work.