LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
racmb1975
 
Posts: n/a
Default Unlocking Cells when a worksheet is protected...

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Expand/Collapse Grouped Data in Protected Worksheet Robert Slattery Excel Discussion (Misc queries) 8 November 24th 15 05:08 PM
How to change the tab order for a protected worksheet dvonj Excel Worksheet Functions 2 March 18th 05 08:23 PM
Heps to design Locked/Unlocked cells in protected worksheet Kevin Excel Discussion (Misc queries) 0 December 30th 04 07:09 AM
How do I ROUNDUP a Column of cells on a worksheet template? house mouse Excel Worksheet Functions 2 December 16th 04 06:49 PM
How use group and ungroup functions while worksheet is protected Gabriel De la Garza Excel Worksheet Functions 1 November 17th 04 01:44 AM


All times are GMT +1. The time now is 10:34 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"