Can I prevent format chgs?
 

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

Can I prevent format chgs?
 

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

Can I prevent format chgs?
 

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 "locked". This will allow
those cells to be edited even when the sheet is protected.

HTH

"Dominic" wrote:

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

Can I prevent format chgs?
 

Hi Dominic! You gave me exactly what I needed. Thanks bunches. Now I'm going
to press my luck and ask this: "Can I restrict a cell to only one or two
options to select?" Specifically, any new record must have "OP3" in ColA and
ColE must be either "M" or "F". 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!
--
Bonnie


"Dominic" wrote:

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 "locked". This will allow
those cells to be edited even when the sheet is protected.

HTH

"Dominic" wrote:

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

Can I prevent format chgs?
 

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 "List". Then you can type
in whichever values you would like to allow.

How does that work?

"Bonnie" wrote:

Hi Dominic! You gave me exactly what I needed. Thanks bunches. Now I'm going
to press my luck and ask this: "Can I restrict a cell to only one or two
options to select?" Specifically, any new record must have "OP3" in ColA and
ColE must be either "M" or "F". 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!
--
Bonnie


"Dominic" wrote:

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 "locked". This will allow
those cells to be edited even when the sheet is protected.

HTH

"Dominic" wrote:

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

Can I prevent format chgs?
 

Yahoo! Works GREAT! Thanks Dominic for your help!
--
Bonnie


"Dominic" wrote:

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 "List". Then you can type
in whichever values you would like to allow.

How does that work?

"Bonnie" wrote:

Hi Dominic! You gave me exactly what I needed. Thanks bunches. Now I'm going
to press my luck and ask this: "Can I restrict a cell to only one or two
options to select?" Specifically, any new record must have "OP3" in ColA and
ColE must be either "M" or "F". 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!
--
Bonnie


"Dominic" wrote:

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 "locked". This will allow
those cells to be edited even when the sheet is protected.

HTH

"Dominic" wrote:

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

Can I prevent format chgs?
 

You're welcome Bonnie!

Thanks for letting me know it worked out.

"Bonnie" wrote:

Yahoo! Works GREAT! Thanks Dominic for your help!
--
Bonnie


"Dominic" wrote:

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 "List". Then you can type
in whichever values you would like to allow.

How does that work?

"Bonnie" wrote:

Hi Dominic! You gave me exactly what I needed. Thanks bunches. Now I'm going
to press my luck and ask this: "Can I restrict a cell to only one or two
options to select?" Specifically, any new record must have "OP3" in ColA and
ColE must be either "M" or "F". 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!
--
Bonnie


"Dominic" wrote:

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 "locked". This will allow
those cells to be edited even when the sheet is protected.

HTH

"Dominic" wrote:

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