Hi, Im trying to mess around with the protection properties of Excel, and I cant seem to find a way to protect formatting in a spreadsheet. The closest I got was to unlock everything and then protect the worksheet, which still allowed me to edit text and keep my formatting. But it didn't allow me to insert rows or anything like that. Is there anyway to protect just the formatting of a cell, such as font color, size, etc. Thanks!
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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Protecting Formatting in Cells
- Thread starter Luis939
- Start date
- Thread starter
- #2
SkipVought
Programmer
Luis939,
That capability does not come untill Excel 2002.
Skip,
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884
That capability does not come untill Excel 2002.
Skip,
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884
- Status
Similar threads
- Locked
- Question
- Locked
- Question
