ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   protecting form excel (https://www.excelbanter.com/excel-discussion-misc-queries/52236-protecting-form-excel.html)

TheBull

protecting form excel
 
I want to protect the size of my cells, but allow the user to enter data into
them.
How do I do this

Thanks

Dave Peterson

protecting form excel
 
Select the cells that you want the users to change.
Format|cells|protection tab|uncheck Locked.

You can also lock the cells that you don't want them to change.

The protect the worksheet.
tools|Protection|protect sheet



TheBull wrote:

I want to protect the size of my cells, but allow the user to enter data into
them.
How do I do this

Thanks


--

Dave Peterson


All times are GMT +1. The time now is 09:42 AM.

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