Preserving Cell Height and column width

S

shirl

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

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

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

Hopefully someone can come up with an answer
 
D

Dave Peterson

Keep the worksheet protected.

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

shirl

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

Shirl
 
Top