| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
allowing user to format a protected cell
Hi
When I protect a worksheet, even when a particular cell is unlocked, users are unable to change the font size, number of decimals in a calculation, colour of text, bold it, change the width of the colums etc. Is there anyway to allow users to make these alterations, while still protecting other (locked) cells on the same worksheet? Thanks for your thoughts / advice andrew. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| allowing sort in protected worksheet | Excel Discussion (Misc queries) | |||
| Allowing sort of protected cells | Excel Worksheet Functions | |||
| Allowing insert pictures in a protected worksheet | Excel Discussion (Misc queries) | |||
| Allowing hyperlinks an a protected sheet | Excel Discussion (Misc queries) | |||
| Allowing spell check on protected worksheets | Setting up and Configuration of Excel | |||
![Andrew[_44_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
