Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I am creating a simply registration list that can be emailed to companies for
them to fill out. In an effort not to have others change the format of the form I am trying to protect certain cells and allow access only to the cells I want others to fill in. I have been through the Excel help files many times, it tells me to protect the sheet, highlight the range of cells I want to unlock, go to Format, Cells, Protection, etc. However when I protect the sheet, I go to Format, and the Cells option is no longer an option. Even right clicking to go to Format Cells is turned off. How do I unlock these cells, after I protect the worksheet? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Expand/Collapse Grouped Data in Protected Worksheet | Excel Discussion (Misc queries) | |||
How to change the tab order for a protected worksheet | Excel Worksheet Functions | |||
Heps to design Locked/Unlocked cells in protected worksheet | Excel Discussion (Misc queries) | |||
How do I ROUNDUP a Column of cells on a worksheet template? | Excel Worksheet Functions | |||
How use group and ungroup functions while worksheet is protected | Excel Worksheet Functions |