How to protect sheet layouts and formatting?

  • Thread starter Thread starter Steven
  • Start date Start date
S

Steven

I have a spread sheet setup to display values from lots of other sheets
within the same workbook. only 77 cells require a user to input data, so I
have set up protection so only these cells can be changed when protect sheet
is enabled.

problems I would love help with, please:

1) how can I now protect the formatting of these cells from being changed?
but still allow users to input data?

2) stop other users from, renaming or deleting any other sheets within the
workbook needed for this sheet to work, or inserting rows or columns in
them?

3) all without password protecting the file?

Kind regards,

Steve
 
Hi
have a look at 'Tools - Protection' and see the Excel help for more
details.
You can allow entries for specific cell by going to 'Format - Cells -
Protection' and unchecking 'Locked'
After this protect the worksheet and the workbook
 
I have done that with the cells in question on the main sheet, but if you
copy a cell that has a black outline to another cell, the outline is also
pasted, I would like just the value in the cell to be copied.

I know using paste special will sort this but not everyone using this
spreadsheet will.
 
Hi Steve
not quite sure but you may use 'Edit - Paste Special - Values' for
pasting your values
 
Back
Top