Restrict Input to Next Empty Cell

You could use a Selection Change event handler to monitor column C. If a cell is selected and it has something in it, you would select the next available cell (with or without a message). Thinking about it, you might want to check the position if the cell is empty, in case they select a cell way down the sheet.

You could have a hidden control/configuration sheet with a toggle value in it. The first thing the Selection Change event handler would/could do is check that toggle. As Administrator, you could set or unset that value, effectively overriding the code.

Regards, TMS

@chgkak:

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.

Nothing to work with. There's no point me creating a workbook as test environment so that I can develop and test a hypothetical solution. And there is alos little point in describing how to go about implementing a hypothetical solution.

Am I correct that my macro will not generate data in a locked cell?

Probably not. With VBA, you can do pretty much what you want. Unprotect the sheet, unlock/lock cells, write data, protect the sheet.

Regards, TMS