ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   A question about locking or protecting a worksheet (https://www.excelbanter.com/excel-discussion-misc-queries/129802-question-about-locking-protecting-worksheet.html)

Meenie

A question about locking or protecting a worksheet
 
Hi!
I have a worksheet that others need to input data into. I don't want them to
be able to change the size of the cells. They keep dragging the cells into
different sizes causing the thing to print off the page. (They say they don't
know how they did it, lol)
How can I protect the sheet so they can enter their info but not change the
cell sizes?
Thanks, Meenie

JE McGimpsey

A question about locking or protecting a worksheet
 
Unlock the cells you want them to be able to change
(Format/Cells/Protection), then protect the sheet.

In article ,
Meenie wrote:

Hi!
I have a worksheet that others need to input data into. I don't want them to
be able to change the size of the cells. They keep dragging the cells into
different sizes causing the thing to print off the page. (They say they don't
know how they did it, lol)
How can I protect the sheet so they can enter their info but not change the
cell sizes?
Thanks, Meenie


Meenie

A question about locking or protecting a worksheet
 
It works great! :) Thank you very very much :)

"JE McGimpsey" wrote:

Unlock the cells you want them to be able to change
(Format/Cells/Protection), then protect the sheet.

In article ,
Meenie wrote:

Hi!
I have a worksheet that others need to input data into. I don't want them to
be able to change the size of the cells. They keep dragging the cells into
different sizes causing the thing to print off the page. (They say they don't
know how they did it, lol)
How can I protect the sheet so they can enter their info but not change the
cell sizes?
Thanks, Meenie




All times are GMT +1. The time now is 07:57 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com