Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
change cells when a particular user makes her input
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
change cells when a particular user makes her input
Debra Dalglish has a sample Budget v Actual workbook you can download for free.
Workbook contains Budget & Actual worksheets which uses conditional formatting to show when Actual figures have been entered. This, although may be different from your workbook, should give you a good working example to help meet your needs. site link below & file needed in list hope helpful http://www.contextures.com/excelfiles.html FN0005 - Budget vs Actual -- Enter budget and actual amounts; summary sheet shows totals year to date; contains macros. zipped file; BudgetYTD.zip 26 kb -- jb "Valeria" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |