Macro to start working on a page

[Aikinetic]

Is there a macro that will allow the user to work on a page ONLY after entering a value in a cell?

[TMS]

You could lock all the cells except the one you need input, and protect the sheet. Then use a Worksheet Change event to monitor that cell. When you get something input, you unprotect the sheet.

Protect the sheet again before you close/save the workbook.

Regards, TMS

[emp1346]

Here is code that does what you're looking for, with the target cell in this case being B1. This needs to be an unlocked cell so the user can actually put something in it, while all the other cells in the spreadsheet should remained locked (the default). The code below also checks that the cell hasn't been changed to be empty, at which point it will relock the sheet.

Please Login or Register  to view this content.