Yes, guess I focused on the "Hide" portion and ignored the "Lock" portion.

--
Regards,
Tom Ogilvy


"Bob Phillips" wrote:

Individual cells can be locked though.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Tom Ogilvy" wrote in message
...
Not in the same sense as a row or a column. You can hide the formula in a
cell by using
Selection.FormulaHidden = True
but the value it calculates will be displayed. You set this property of
the
range as shown, then you must protect the sheet.

Otherwise, hide the entirerow or column.

--
Regards,
Tom Ogilvy


"David" wrote:

Hello,
I know that range of rows or columns can be hidden or locked.
How about specific cells? what is the syntax for that.

Thanks for your help