![]() |
Block inser or delete rows
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 |
All times are GMT +1. The time now is 07:22 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com