ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Stop from moving cells (https://www.excelbanter.com/excel-programming/352837-stop-moving-cells.html)

Dean[_8_]

Stop from moving cells
 
I have a monster EXCEL file I've designed for others to use and I go to great lengths to protect the equations, so the file will be as idiot proof as possible, since just a few users are not expert ones. However, they just gotcha me, despite my efforts today!

Basically, I have a row of contiguous cells (120 columns' worth) where they can enter 1's to schedule certain events in months 1 through 120 - the cells are empty by default, which implies zero events are scheduled in that month. Apparently what they did is schedule one event per month in months 3 through 9, then decided they'd rather delay it until months 5 through 11. So, they apparently moved the 7 cells in question rather than deleting the 1's in month 3 and 4 and inserting them in months 10 and 11.

Since these cells are obviously intended as inputs, cells which I don't want to protect, I don't know how I can stop someone from doing this kind of thing. Quite frankly, though I try to almost never move anything in EXCEL, not all users are that savvy. Are there any easy solutions to make this more idiot proof?

Thanks much!
Dean


All times are GMT +1. The time now is 04:00 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com