Hi Bonnie,

You should be able to achieve that by protecting the sheet under
Tools:Protection.

It will prompt you for a password.

This will prevent the user from changing the settings you mentioned.

The protection, however, is very minimal, as Excel security can be broken by
anyone who wants to. It should, however, suffice to keep users from
accidentily doing something they shouldn't.

HTH


"Bonnie" wrote:

Hi everyone! Using E02 on XP.

Have a project where we will be sending an Excel file to each client that
contains a few sample records with specific data required in specific
columns.

For example, ColA must contain socials, ColB-E are blank, ColF should have
FirstName, ColG has LastName, ColH-R are blank and so on for Columns A - AH.
We will have the blank columns hidden so the 6 or so columns with data will
show on the screen without requiring any horizontal scrolling.

Is it possible to lock down the file so you can key in data (edit existing
records and add new records) but not change any formatting? Keep the columns
hidden that need to be, keep ColA as text (so we don't lose leading zeros),
etc.

Not sure what approach to take on this and would appreciate any help or
ideas. Thanks in advance for your time.
--
Bonnie