| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Prevent the user from Edition / Erase / Format
Hello,
In the Excel sheet, I have several cells which are unprotected to allow the user entering some information. Tools / Protection / Protect the sheet : Cell Format is uncheck. So the user is not able to change the format (color...) of the cell, BUT he/she is able to *erase* the format !!! So after that the cell is....protected ! How can we really protect (with VBA ?) the format of a cell which has to remain accessible to the user typing.? Thanks Gérard |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel - Home Edition vs Standard Edition | Excel Discussion (Misc queries) | |||
| Prevent user from using Name | Excel Discussion (Misc queries) | |||
| How can I test in VBA what edition of Office a user is running | Excel Programming | |||
| Prevent User from saving | Excel Programming | |||
| How do I: prevent user from scolling down and right? | Excel Programming | |||
![Gérard Ducouret[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
