Creating a sheet that needs to be completed weekly by employees. I want them to be able to edit data within the sheet but not to alter the size of the rows and columns.It is perfectly formatted to fit on one side of A4 I don't want this to change.??
Creating a sheet that needs to be completed weekly by employees. I want them to be able to edit data within the sheet but not to alter the size of the rows and columns.It is perfectly formatted to fit on one side of A4 I don't want this to change.??
You can "lock" the size of the cells on the worksheet by using the Protect Worksheet on the Review tab.
Select the cells that you want the employees to have access to for entry of data, right click, choose Format Cells. Click on the Protection tab and deselect the LOCKED box and click OK.
Size all cells to the size and format that you want. Go to the Review tab, click on Protect Worksheet, Select Protect Worksheet and Locked Cells, enter a password and select what you want the employees to have access to. In this case only UNLOCKED cells is the likely choice. Click OK. The worksheet should be protected to prevent the changing of format or cell sizes.
This workbook has a blank password so you can unprotect the worksheet just by going to the Review tab, click on Unprotect Worksheet and click OK. I have formatted cell width, cell height, colour, and formatted the available cells as currency. You can see that only the grey area is available to be edited.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
newdoverman's solution will prevent users from changing the column width manually. However, I note that the column width can still change due to Excel's (accursed) "auto column width" feature/bug. In newdoverman's spreadsheet, if I enter a 10 digit number (1234567890), then Excel will automatically widen the column to accommodate the large number. Of course, the programmer needs to set the column width wide enough to account for any number that might be entered. This might apply if the user inadvertently enters and invalid number or something. If needed, it might be valuable to include some kind of "data validation" to make sure that the user does not inadvertently enter a number that will cause the auto column width feature to kick in. I don't know if that will apply to the OP's scenario, but it might be worth considering.
Originally Posted by shg
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks