Help with creating a macro to hide the formulas and protect only certain cells.

**skin.uk1** · 07-08-2011, 07:21 AM

Hi,
Can anybody help me out please.
I want to create a Macro to hide the formulas in the workbook and protect only certain cells in Excel 2003 and Excel 2007.

**teylyn** · 07-08-2011, 07:28 AM

Hello,

you don't need macros to do that. That's native Excel functionality. Format the cells you don't want to be changed as "locked". For the the cells where you want to hide the fomulas, also tick the setting "Hidden" to prevent users seeing the formulas in locked cells. Then protect the sheet.

**skin.uk1** · 07-08-2011, 07:44 AM

Also I want to protect only certain cells (C9 & H9).
Why I want a Macro so I can apply it to 1 - 31 sheets in the workbook and apply it to 12 workbooks!
How do I do that?