P
Prema
I have a sheet which is used as a staff planner. Different interior colour is
selected to indicate holiday, absense, meetings and so on. I have a macro
which looks at each cell and adds up total for each category for each person.
This macro uses ranges and I would like to stop people from inserting or
deleting rows and columns. How can I achieve this and still allow changes of
interior colour of cells? If I protect the sheet then the option for cell
colour is not available.
Thank you for the help in advance
Prema
selected to indicate holiday, absense, meetings and so on. I have a macro
which looks at each cell and adds up total for each category for each person.
This macro uses ranges and I would like to stop people from inserting or
deleting rows and columns. How can I achieve this and still allow changes of
interior colour of cells? If I protect the sheet then the option for cell
colour is not available.
Thank you for the help in advance
Prema