Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Can't paste into unlocked cells on protected sheet 2
- Thread starter krinid
- Start date
Which version of Excel are you using? I have 2000 and do not appear to have this issue. If you open another workbook, are you able to paste into a new (unprotected) workbook? For that matter, if you unprotect your current workbook, are you able to then paste?
-----------------------------------------------------------------------------------------------------
"If you can't explain something to a six-year-old, you really don't understand it yourself."
-- Albert Einstein
-----------------------------------------------------------------------------------------------------
"If you can't explain something to a six-year-old, you really don't understand it yourself."
-- Albert Einstein
- Thread starter
- #3
Haven't worked with Excel XP, so cannot offer any insight. A quick look on MS KnowledgeBase did not turn up anything specific to this problem, either. Perhaps someone else has run into it.
-----------------------------------------------------------------------------------------------------
"If you can't explain something to a six-year-old, you really don't understand it yourself."
-- Albert Einstein
-----------------------------------------------------------------------------------------------------
"If you can't explain something to a six-year-old, you really don't understand it yourself."
-- Albert Einstein
-
2
- #5
I understand you are using Excel XP, I am currently using Excel 2002 and I noticed when clicking on the button to protect the worksheet you can check and uncheck the options you want for changing unprotected cells. One of those options was formatting, i.e. changing colors. You might want to look into that when you click to protect.
- Thread starter
- #6
trussman,
Thanks for the response - that seems to be the problem.
I set those options when I applied security, but assumed that checking the options would LOCK those operations and unchecking them would UNLOCK them, as the standard is for locking cells. After your tip, I reread the dialog and realized my interpretive mistake. Cheers!
Thanks for the response - that seems to be the problem.
I set those options when I applied security, but assumed that checking the options would LOCK those operations and unchecking them would UNLOCK them, as the standard is for locking cells. After your tip, I reread the dialog and realized my interpretive mistake. Cheers!
- Status
Similar threads
- Locked
- Question
- Locked
- Question