Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
Excell 2K and protection
Name: hamilton Date: April 15, 2002 at 04:14:40 Pacific
Comment:
Hi,
In Excel 2000, I want to protect a sheet to prevent changes other then cells that I leave unlocked. The only thing is, my coworkers need to be able to highlight cells with different colors. But with the sheet protected they can't, even on the unlocked cells. Is there anyway around this, or a certain way to protect it and still allow highlighting?
Name: Jennifer Date: April 15, 2002 at 07:54:10 Pacific
Reply:
Unfortunately not. Not if you want to protect/lock cells.
0
Response Number 2
Name: A Certain TH Date: April 15, 2002 at 08:49:29 Pacific
Reply:
Well, you can - but its not straightforward. If you are comfortable with VBA, then its not too hard.
Otherwise, you might consider 'sharing' the book, with changes tracked. (Meaning that you'll know if someone changes anything - and if so, what they changed)
You have to be devious based on your knowledge of the people likely to make the changes...
Tom
0
Response Number 3
Name: Hamilton Date: April 29, 2002 at 07:54:05 Pacific
Reply:
Here is what i used: -----
Sub Yellow() HighlightCell 27 End Sub
Function HighlightCell(ByVal sglColor As Single) If ActiveCell.Locked Then MsgBox "Cell is locked." Else ActiveSheet.Unprotect ActiveCell.Interior.ColorIndex = sglColor ActiveSheet.Protect End If End Function
Summary: Hi. Here is my problem. I had upgrade a user who has Win 95 from Office 97 to Office 2k to transfer *.dat to *.cvs file extensions, which in turn would go into wordpad. I was asked to upgrade to offic...
Summary: Can anyone explain how to do a dual boot system with Windows 2k and mandrake linux 9.0? should I install windows first or linux? how should i partion it, does windows do that? ...
Summary: Basic peer-to-peer networking with 2K and XP: Same workgroup name on both machines, very important. Different computer names for both, also important. Same username and password on both machines, extr...
0 
