Preserving Cell Height and column width
 

Apologies if you get this twice as my work PC timed out while doing the
posting.

I have a spreadsheet in which users will use be inputting data via an
automated form, but I do not want the users to be able to alter the
cell sizes where the data goes, ie row height and column widths need to
be fixed so that the data will still print on A3.

Have searched the forums several days for an answer but cannot find
one. Protecting the cells or workshops stops data being entered which
I do not want I only want to protect the cell sizes.

Hopefully someone can come up with an answer.


--
shirl

Preserving Cell Height and column width
 

Keep the worksheet protected.

Have the userform code unprotect the worksheet, do its work and then reprotect
the sheet.

shirl wrote:

Apologies if you get this twice as my work PC timed out while doing the
posting.

I have a spreadsheet in which users will use be inputting data via an
automated form, but I do not want the users to be able to alter the
cell sizes where the data goes, ie row height and column widths need to
be fixed so that the data will still print on A3.

Have searched the forums several days for an answer but cannot find
one. Protecting the cells or workshops stops data being entered which
I do not want I only want to protect the cell sizes.

Hopefully someone can come up with an answer.

--
shirl

--

Dave Peterson

Preserving Cell Height and column width
 

Doh, why did I not think of that - thanks for the reply. Sometime
difficult to see the wood from the trees.

Shirl

Dave Peterson Wrote:
Keep the worksheet protected.

Have the userform code unprotect the worksheet, do its work and then
reprotect
the sheet.

shirl wrote:

Apologies if you get this twice as my work PC timed out while doing
the
posting.

I have a spreadsheet in which users will use be inputting data via an
automated form, but I do not want the users to be able to alter the
cell sizes where the data goes, ie row height and column widths need
to
be fixed so that the data will still print on A3.

Have searched the forums several days for an answer but cannot find
one. Protecting the cells or workshops stops data being entered
which
I do not want I only want to protect the cell sizes.

Hopefully someone can come up with an answer.

--
shirl

--

Dave Peterson


--
shirl