Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Dear experts,
we have a spreadsheet with sales forecasts and an OP who is entering the real sales data month by month when available. I would like to be able to make a difference between the forecast months and the real figures, possibly with different cell colours and by protecting the real figures; to do so, I would like Excel to recognize that the data in cell is entered by a particular user - the OP - and therefore change format and protect the cells. Is this possible with VBA programming? Thank you! Best regards -- Valeria |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Can I make a picture change based on input from a user? | Excel Discussion (Misc queries) | |||
Searching cells from user input | Excel Discussion (Misc queries) | |||
user input of a range of cells | Excel Programming | |||
Change color of cell after user has input a number | Excel Discussion (Misc queries) | |||
Detecting Input Change on User Form | Excel Programming |