ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Block inser or delete rows (https://www.excelbanter.com/excel-programming/350608-block-inser-delete-rows.html)

Prema

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