software

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

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.

HTHquot;Bonniequot; wrote:

gt; Hi everyone! Using E02 on XP.
gt;
gt; Have a project where we will be sending an Excel file to each client that
gt; contains a few sample records with specific data required in specific
gt; columns.
gt;
gt; For example, ColA must contain socials, ColB-E are blank, ColF should have
gt; FirstName, ColG has LastName, ColH-R are blank and so on for Columns A - AH.
gt; We will have the blank columns hidden so the 6 or so columns with data will
gt; show on the screen without requiring any horizontal scrolling.
gt;
gt; Is it possible to lock down the file so you can key in data (edit existing
gt; records and add new records) but not change any formatting? Keep the columns
gt; hidden that need to be, keep ColA as text (so we don't lose leading zeros),
gt; etc.
gt;
gt; Not sure what approach to take on this and would appreciate any help or
gt; ideas. Thanks in advance for your time.
gt; --
gt; Bonnie

oops,

Forgot to mention that before you protect the sheet, you should select those
cells that you want the user to be able to edit (input data), then go to
format:cells. Go to the protection tab and uncheck quot;lockedquot;. This will allow
those cells to be edited even when the sheet is protected.

HTH

quot;Dominicquot; wrote:

gt; Hi Bonnie,
gt;
gt; You should be able to achieve that by protecting the sheet under
gt; Tools:Protection.
gt;
gt; It will prompt you for a password.
gt;
gt; This will prevent the user from changing the settings you mentioned.
gt;
gt; The protection, however, is very minimal, as Excel security can be broken by
gt; anyone who wants to. It should, however, suffice to keep users from
gt; accidentily doing something they shouldn't.
gt;
gt; HTH
gt;
gt;
gt; quot;Bonniequot; wrote:
gt;
gt; gt; Hi everyone! Using E02 on XP.
gt; gt;
gt; gt; Have a project where we will be sending an Excel file to each client that
gt; gt; contains a few sample records with specific data required in specific
gt; gt; columns.
gt; gt;
gt; gt; For example, ColA must contain socials, ColB-E are blank, ColF should have
gt; gt; FirstName, ColG has LastName, ColH-R are blank and so on for Columns A - AH.
gt; gt; We will have the blank columns hidden so the 6 or so columns with data will
gt; gt; show on the screen without requiring any horizontal scrolling.
gt; gt;
gt; gt; Is it possible to lock down the file so you can key in data (edit existing
gt; gt; records and add new records) but not change any formatting? Keep the columns
gt; gt; hidden that need to be, keep ColA as text (so we don't lose leading zeros),
gt; gt; etc.
gt; gt;
gt; gt; Not sure what approach to take on this and would appreciate any help or
gt; gt; ideas. Thanks in advance for your time.
gt; gt; --
gt; gt; Bonnie

Hi Dominic! You gave me exactly what I needed. Thanks bunches. Now I'm going
to press my luck and ask this: quot;Can I restrict a cell to only one or two
options to select?quot; Specifically, any new record must have quot;OP3quot; in ColA and
ColE must be either quot;Mquot; or quot;Fquot;. I know how to do this in Access but clueless
in Excel. If you have a moment and are inclined, could you give me a hand on
this? I would absolutely appreciate it! Thanks in advance for your time!
--
Bonniequot;Dominicquot; wrote:

gt; oops,
gt;
gt; Forgot to mention that before you protect the sheet, you should select those
gt; cells that you want the user to be able to edit (input data), then go to
gt; format:cells. Go to the protection tab and uncheck quot;lockedquot;. This will allow
gt; those cells to be edited even when the sheet is protected.
gt;
gt; HTH
gt;
gt; quot;Dominicquot; wrote:
gt;
gt; gt; Hi Bonnie,
gt; gt;
gt; gt; You should be able to achieve that by protecting the sheet under
gt; gt; Tools:Protection.
gt; gt;
gt; gt; It will prompt you for a password.
gt; gt;
gt; gt; This will prevent the user from changing the settings you mentioned.
gt; gt;
gt; gt; The protection, however, is very minimal, as Excel security can be broken by
gt; gt; anyone who wants to. It should, however, suffice to keep users from
gt; gt; accidentily doing something they shouldn't.
gt; gt;
gt; gt; HTH
gt; gt;
gt; gt;
gt; gt; quot;Bonniequot; wrote:
gt; gt;
gt; gt; gt; Hi everyone! Using E02 on XP.
gt; gt; gt;
gt; gt; gt; Have a project where we will be sending an Excel file to each client that
gt; gt; gt; contains a few sample records with specific data required in specific
gt; gt; gt; columns.
gt; gt; gt;
gt; gt; gt; For example, ColA must contain socials, ColB-E are blank, ColF should have
gt; gt; gt; FirstName, ColG has LastName, ColH-R are blank and so on for Columns A - AH.
gt; gt; gt; We will have the blank columns hidden so the 6 or so columns with data will
gt; gt; gt; show on the screen without requiring any horizontal scrolling.
gt; gt; gt;
gt; gt; gt; Is it possible to lock down the file so you can key in data (edit existing
gt; gt; gt; records and add new records) but not change any formatting? Keep the columns
gt; gt; gt; hidden that need to be, keep ColA as text (so we don't lose leading zeros),
gt; gt; gt; etc.
gt; gt; gt;
gt; gt; gt; Not sure what approach to take on this and would appreciate any help or
gt; gt; gt; ideas. Thanks in advance for your time.
gt; gt; gt; --
gt; gt; gt; Bonnie

Hi Bonnie!

Glad you got that working. About the second topic, you can achieve that
using Data Validation.

Select the cells you want to restrict values for, then click Data:Validation
from the menu bar. Under the allow list box, choose quot;Listquot;. Then you can type
in whichever values you would like to allow.

How does that work?

quot;Bonniequot; wrote:

gt; Hi Dominic! You gave me exactly what I needed. Thanks bunches. Now I'm going
gt; to press my luck and ask this: quot;Can I restrict a cell to only one or two
gt; options to select?quot; Specifically, any new record must have quot;OP3quot; in ColA and
gt; ColE must be either quot;Mquot; or quot;Fquot;. I know how to do this in Access but clueless
gt; in Excel. If you have a moment and are inclined, could you give me a hand on
gt; this? I would absolutely appreciate it! Thanks in advance for your time!
gt; --
gt; Bonnie
gt;
gt;
gt; quot;Dominicquot; wrote:
gt;
gt; gt; oops,
gt; gt;
gt; gt; Forgot to mention that before you protect the sheet, you should select those
gt; gt; cells that you want the user to be able to edit (input data), then go to
gt; gt; format:cells. Go to the protection tab and uncheck quot;lockedquot;. This will allow
gt; gt; those cells to be edited even when the sheet is protected.
gt; gt;
gt; gt; HTH
gt; gt;
gt; gt; quot;Dominicquot; wrote:
gt; gt;
gt; gt; gt; Hi Bonnie,
gt; gt; gt;
gt; gt; gt; You should be able to achieve that by protecting the sheet under
gt; gt; gt; Tools:Protection.
gt; gt; gt;
gt; gt; gt; It will prompt you for a password.
gt; gt; gt;
gt; gt; gt; This will prevent the user from changing the settings you mentioned.
gt; gt; gt;
gt; gt; gt; The protection, however, is very minimal, as Excel security can be broken by
gt; gt; gt; anyone who wants to. It should, however, suffice to keep users from
gt; gt; gt; accidentily doing something they shouldn't.
gt; gt; gt;
gt; gt; gt; HTH
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; quot;Bonniequot; wrote:
gt; gt; gt;
gt; gt; gt; gt; Hi everyone! Using E02 on XP.
gt; gt; gt; gt;
gt; gt; gt; gt; Have a project where we will be sending an Excel file to each client that
gt; gt; gt; gt; contains a few sample records with specific data required in specific
gt; gt; gt; gt; columns.
gt; gt; gt; gt;
gt; gt; gt; gt; For example, ColA must contain socials, ColB-E are blank, ColF should have
gt; gt; gt; gt; FirstName, ColG has LastName, ColH-R are blank and so on for Columns A - AH.
gt; gt; gt; gt; We will have the blank columns hidden so the 6 or so columns with data will
gt; gt; gt; gt; show on the screen without requiring any horizontal scrolling.
gt; gt; gt; gt;
gt; gt; gt; gt; Is it possible to lock down the file so you can key in data (edit existing
gt; gt; gt; gt; records and add new records) but not change any formatting? Keep the columns
gt; gt; gt; gt; hidden that need to be, keep ColA as text (so we don't lose leading zeros),
gt; gt; gt; gt; etc.
gt; gt; gt; gt;
gt; gt; gt; gt; Not sure what approach to take on this and would appreciate any help or
gt; gt; gt; gt; ideas. Thanks in advance for your time.
gt; gt; gt; gt; --
gt; gt; gt; gt; Bonnie

Yahoo! Works GREAT! Thanks Dominic for your help!
--
Bonniequot;Dominicquot; wrote:

gt; Hi Bonnie!
gt;
gt; Glad you got that working. About the second topic, you can achieve that
gt; using Data Validation.
gt;
gt; Select the cells you want to restrict values for, then click Data:Validation
gt; from the menu bar. Under the allow list box, choose quot;Listquot;. Then you can type
gt; in whichever values you would like to allow.
gt;
gt; How does that work?
gt;
gt; quot;Bonniequot; wrote:
gt;
gt; gt; Hi Dominic! You gave me exactly what I needed. Thanks bunches. Now I'm going
gt; gt; to press my luck and ask this: quot;Can I restrict a cell to only one or two
gt; gt; options to select?quot; Specifically, any new record must have quot;OP3quot; in ColA and
gt; gt; ColE must be either quot;Mquot; or quot;Fquot;. I know how to do this in Access but clueless
gt; gt; in Excel. If you have a moment and are inclined, could you give me a hand on
gt; gt; this? I would absolutely appreciate it! Thanks in advance for your time!
gt; gt; --
gt; gt; Bonnie
gt; gt;
gt; gt;
gt; gt; quot;Dominicquot; wrote:
gt; gt;
gt; gt; gt; oops,
gt; gt; gt;
gt; gt; gt; Forgot to mention that before you protect the sheet, you should select those
gt; gt; gt; cells that you want the user to be able to edit (input data), then go to
gt; gt; gt; format:cells. Go to the protection tab and uncheck quot;lockedquot;. This will allow
gt; gt; gt; those cells to be edited even when the sheet is protected.
gt; gt; gt;
gt; gt; gt; HTH
gt; gt; gt;
gt; gt; gt; quot;Dominicquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; Hi Bonnie,
gt; gt; gt; gt;
gt; gt; gt; gt; You should be able to achieve that by protecting the sheet under
gt; gt; gt; gt; Tools:Protection.
gt; gt; gt; gt;
gt; gt; gt; gt; It will prompt you for a password.
gt; gt; gt; gt;
gt; gt; gt; gt; This will prevent the user from changing the settings you mentioned.
gt; gt; gt; gt;
gt; gt; gt; gt; The protection, however, is very minimal, as Excel security can be broken by
gt; gt; gt; gt; anyone who wants to. It should, however, suffice to keep users from
gt; gt; gt; gt; accidentily doing something they shouldn't.
gt; gt; gt; gt;
gt; gt; gt; gt; HTH
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt; gt; quot;Bonniequot; wrote:
gt; gt; gt; gt;
gt; gt; gt; gt; gt; Hi everyone! Using E02 on XP.
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; Have a project where we will be sending an Excel file to each client that
gt; gt; gt; gt; gt; contains a few sample records with specific data required in specific
gt; gt; gt; gt; gt; columns.
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; For example, ColA must contain socials, ColB-E are blank, ColF should have
gt; gt; gt; gt; gt; FirstName, ColG has LastName, ColH-R are blank and so on for Columns A - AH.
gt; gt; gt; gt; gt; We will have the blank columns hidden so the 6 or so columns with data will
gt; gt; gt; gt; gt; show on the screen without requiring any horizontal scrolling.
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; Is it possible to lock down the file so you can key in data (edit existing
gt; gt; gt; gt; gt; records and add new records) but not change any formatting? Keep the columns
gt; gt; gt; gt; gt; hidden that need to be, keep ColA as text (so we don't lose leading zeros),
gt; gt; gt; gt; gt; etc.
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; Not sure what approach to take on this and would appreciate any help or
gt; gt; gt; gt; gt; ideas. Thanks in advance for your time.
gt; gt; gt; gt; gt; --
gt; gt; gt; gt; gt; Bonnie

You're welcome Bonnie!

Thanks for letting me know it worked out.

quot;Bonniequot; wrote:

gt; Yahoo! Works GREAT! Thanks Dominic for your help!
gt; --
gt; Bonnie
gt;
gt;
gt; quot;Dominicquot; wrote:
gt;
gt; gt; Hi Bonnie!
gt; gt;
gt; gt; Glad you got that working. About the second topic, you can achieve that
gt; gt; using Data Validation.
gt; gt;
gt; gt; Select the cells you want to restrict values for, then click Data:Validation
gt; gt; from the menu bar. Under the allow list box, choose quot;Listquot;. Then you can type
gt; gt; in whichever values you would like to allow.
gt; gt;
gt; gt; How does that work?
gt; gt;
gt; gt; quot;Bonniequot; wrote:
gt; gt;
gt; gt; gt; Hi Dominic! You gave me exactly what I needed. Thanks bunches. Now I'm going
gt; gt; gt; to press my luck and ask this: quot;Can I restrict a cell to only one or two
gt; gt; gt; options to select?quot; Specifically, any new record must have quot;OP3quot; in ColA and
gt; gt; gt; ColE must be either quot;Mquot; or quot;Fquot;. I know how to do this in Access but clueless
gt; gt; gt; in Excel. If you have a moment and are inclined, could you give me a hand on
gt; gt; gt; this? I would absolutely appreciate it! Thanks in advance for your time!
gt; gt; gt; --
gt; gt; gt; Bonnie
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; quot;Dominicquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; oops,
gt; gt; gt; gt;
gt; gt; gt; gt; Forgot to mention that before you protect the sheet, you should select those
gt; gt; gt; gt; cells that you want the user to be able to edit (input data), then go to
gt; gt; gt; gt; format:cells. Go to the protection tab and uncheck quot;lockedquot;. This will allow
gt; gt; gt; gt; those cells to be edited even when the sheet is protected.
gt; gt; gt; gt;
gt; gt; gt; gt; HTH
gt; gt; gt; gt;
gt; gt; gt; gt; quot;Dominicquot; wrote:
gt; gt; gt; gt;
gt; gt; gt; gt; gt; Hi Bonnie,
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; You should be able to achieve that by protecting the sheet under
gt; gt; gt; gt; gt; Tools:Protection.
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; It will prompt you for a password.
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; This will prevent the user from changing the settings you mentioned.
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; The protection, however, is very minimal, as Excel security can be broken by
gt; gt; gt; gt; gt; anyone who wants to. It should, however, suffice to keep users from
gt; gt; gt; gt; gt; accidentily doing something they shouldn't.
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; HTH
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; quot;Bonniequot; wrote:
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; Hi everyone! Using E02 on XP.
gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; Have a project where we will be sending an Excel file to each client that
gt; gt; gt; gt; gt; gt; contains a few sample records with specific data required in specific
gt; gt; gt; gt; gt; gt; columns.
gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; For example, ColA must contain socials, ColB-E are blank, ColF should have
gt; gt; gt; gt; gt; gt; FirstName, ColG has LastName, ColH-R are blank and so on for Columns A - AH.
gt; gt; gt; gt; gt; gt; We will have the blank columns hidden so the 6 or so columns with data will
gt; gt; gt; gt; gt; gt; show on the screen without requiring any horizontal scrolling.
gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; Is it possible to lock down the file so you can key in data (edit existing
gt; gt; gt; gt; gt; gt; records and add new records) but not change any formatting? Keep the columns
gt; gt; gt; gt; gt; gt; hidden that need to be, keep ColA as text (so we don't lose leading zeros),
gt; gt; gt; gt; gt; gt; etc.
gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; Not sure what approach to take on this and would appreciate any help or
gt; gt; gt; gt; gt; gt; ideas. Thanks in advance for your time.
gt; gt; gt; gt; gt; gt; --
gt; gt; gt; gt; gt; gt; Bonnie