John

On macros you can set up protection for them in the VBE (Alt+F11), for other
things it is a two-stage process. All Excel cells are 'locked' by default,
but this is ignored until the sheet is protected.

Highlight the cells you want users to input into (You can highlight multiple
cells by Ctrl+Click) and now, with these highlighted go to
FormatCells...Protection and deselect 'locked', now protect the sheet
(ToolsProtectionProtect Sheet...) and these cells will be 'un-locked' and
entry enabled

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"John" wrote in message
...
How do I pretect sheets in such a way that users can input data but can't
change formulas, macros etc?

Thanks
John