We're using an excel workbook to log operators entry and exits to different areas at work.
The log contains "Operator name" "Work area" "Date/Time of entry" "EntryChecklistComplete" "Date/Time of exit".
I want to make a row of ActiveX checkboxes on top of the sheet where i can mark a work area as "Safe", so when trying to log in an operator to a "unsafe" area OR if an area becomes "unsafe" while an operator is logged in the cell containing workarea changes color. For this to work I first need to be able to separate active and unactive areas, so if someone is logged in to an area end I uncheck the checkbox for that area the "area"cell for that area changes color. But if the operator is logged out (the Date/Time for exit") is filled in, the cell doesent change color.
I have worked how to check if an area is safe and chance cell color when someone is logged in, but having a hard time how to make ONLY the active lines (areas currently being worked in) change color if checkbox for area safe is unchecked, and also how to chance cellcolors back to white if an area becomes safe again when someone already is logged in. This is a logbook for a whole year at a time, getting 10k ish entrys pr year, so cant have it check up all cells containg "area1" each time the checkbox is unchecked or checked. Might not be the best formulated question, but hope someone can point me in the right direction
The log contains "Operator name" "Work area" "Date/Time of entry" "EntryChecklistComplete" "Date/Time of exit".
I want to make a row of ActiveX checkboxes on top of the sheet where i can mark a work area as "Safe", so when trying to log in an operator to a "unsafe" area OR if an area becomes "unsafe" while an operator is logged in the cell containing workarea changes color. For this to work I first need to be able to separate active and unactive areas, so if someone is logged in to an area end I uncheck the checkbox for that area the "area"cell for that area changes color. But if the operator is logged out (the Date/Time for exit") is filled in, the cell doesent change color.
I have worked how to check if an area is safe and chance cell color when someone is logged in, but having a hard time how to make ONLY the active lines (areas currently being worked in) change color if checkbox for area safe is unchecked, and also how to chance cellcolors back to white if an area becomes safe again when someone already is logged in. This is a logbook for a whole year at a time, getting 10k ish entrys pr year, so cant have it check up all cells containg "area1" each time the checkbox is unchecked or checked. Might not be the best formulated question, but hope someone can point me in the right direction