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.


--
oberon.black
------------------------------------------------------------------------
oberon.black's Profile: http://www.excelforum.com/member.php...o&userid=26732
View this thread: http://www.excelforum.com/showthread...hreadid=473517