Freezing column widths and heights so users can't change them

[SandsB]

Is this possible? I have a form several users edit every day and sometimes they make changes so, when printed, they look like crap. I know I can set a print area but what I want is for each printed page to look like a standardized form where cell A13 is the same width and height and at the same place on the printed page as it is on every other form. But not just cell A13 - ALL of them.

 

[SandsB]

I've tried this but users can still make changes.

Redirecting

 

[MARK858]

What it doesn't state in the reply is you need to protect the sheet to get locking to apply

 

[MARK858]

If you just want to protect the column widths and row heights unlock all the cells and protect the sheet making sure the Format columns and Format rows checkboxes are unchecked

 

[SandsB]

If you just want to protect the column widths and row heights unlock all the cells and protect the sheet making sure the Format columns and Format rows checkboxes are unchecked
View attachment 114784

My users need to be able to edit the data in the cells. This brings up a prompt for the Unprotect password - and that would allow them to change row and column dimensions. Is there a way to freeze just the cell dimensions?

 

[MARK858]

You get no prompt if you allow them to Select unlocked cells (see the image in my last post) and you have unlocked the cells as stated in my post (Select all cells, right click, format cells, Protection tab, uncheck the locked option)

 

[SandsB]

You get no prompt if you allow them to Select unlocked cells (see the image in my last post) and you have unlocked the cells as stated in my post (Select all cells, right click, format cells, Protection tab, uncheck the locked option)

I undid step 3 of that link I posted - did the trick. Thank you, MARK858

 

[MARK858]

You're welcome, happy you have it sorted (just for future reference cells are locked by default so you will always need to unlock them if doing something similar)