Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatically lock cells and hide formulas
I'd like to set the cell format properties to "lock" and "hide" any formulas
entered into the cells and protect each sheet when my workbook is opened. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatically lock cells and hide formulas
Something like the code below in the Workbook_open() event will do
Private Sub Workbook_Open() Dim wks As Worksheet For Each wks In Me.Worksheets With wks .Cells.Locked = True .Cells.FormulaHidden = True .Protect Password:="abcd" End With Next wks End Sub -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS "Qaspec" wrote in message ... I'd like to set the cell format properties to "lock" and "hide" any formulas entered into the cells and protect each sheet when my workbook is opened. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatically lock cells and hide formulas
Look in help index for protection and then
Password protect a worksheet or workbook -- Don Guillett SalesAid Software "Qaspec" wrote in message ... I'd like to set the cell format properties to "lock" and "hide" any formulas entered into the cells and protect each sheet when my workbook is opened. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatically lock cells and hide formulas
Thanks....my only problem is that this locks all cells. I would like to only
lock cells that contain formulas. If possible. "Nick Hodge" wrote: Something like the code below in the Workbook_open() event will do Private Sub Workbook_Open() Dim wks As Worksheet For Each wks In Me.Worksheets With wks .Cells.Locked = True .Cells.FormulaHidden = True .Protect Password:="abcd" End With Next wks End Sub -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS "Qaspec" wrote in message ... I'd like to set the cell format properties to "lock" and "hide" any formulas entered into the cells and protect each sheet when my workbook is opened. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formulas Aren't Automatically Updating When Cells Change | Excel Discussion (Misc queries) | |||
Hide and lock cell formulas without affecting Macro? | Excel Discussion (Misc queries) | |||
hide formulas but can edit on the same cells | Charts and Charting in Excel | |||
Can u lock individual cells (those containing formulas) in an Exc. | Excel Discussion (Misc queries) | |||
How do I hide formulas in Excel cells? | Excel Discussion (Misc queries) |