Tech Talk Discuss PC Hardware, Software, Internet and Other Technology

Excel Worksheet question

Old 02-05-04, 07:36 PM
DVD Talk Legend
Thread Starter
calhoun07's Avatar
Join Date: Oct 2001
Posts: 14,402
Excel Worksheet question

Can you use the "fill color" function with the worksheet protected? I am trying to figure out a way to do this without having to unprotect the sheet each time I want to use "fill color" in a cell.
calhoun07 is offline  
Old 02-06-04, 10:58 PM
VinVega's Avatar
Join Date: Nov 2000
Location: Caught between the moon and NYC
Posts: 31,523
What version of Office do you have? In Excel XP, when you choose tools/protection/protect sheet, it asks you a question: Allow users of this worksheet to... and then there are a bunch of check boxes. The top two choices (Select locked cells and select unlocked cells) if checked allow you to edit the worksheet and use the fill color option. But maybe I'm not understanding your question totally.
VinVega is offline  
Old 02-07-04, 02:18 PM
DVD Talk Legend
Thread Starter
calhoun07's Avatar
Join Date: Oct 2001
Posts: 14,402
I am not sure, but I have Office XP at home and I know I can do that on Excel here. However, for this worksheet, this is at my place of work, and they haven't graduated to XP yet, it seems. I am not sure what version we have, but when I click on "protect" the only three boxes I can choose to select are "contents," "objects," and "scenarios." I suppose I could email the work sheet to my home address and edit the protection here, but I would be afraid that if I had to make any formula changes or add columns or delete any rows at work that when I took the protection off and reset it it would go back to the way it was.
calhoun07 is offline  
Old 02-07-04, 06:02 PM
DVD Talk Legend
Join Date: Feb 2003
Posts: 14,204
To answer your question: no. In Excel 2000 and all versions before, worksheet protection is pretty much an all-or-nothing affair.
NCMojo is offline  

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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

Thread Tools
Search this Thread

Archive Advertising Cookie Policy Privacy Statement Terms of Service

Copyright 2018 MH Sub I, LLC dba Internet Brands. All rights reserved. Use of this site indicates your consent to the Terms of Use.