LinkBack URL
About LinkBacks
Is there a macro that will allow the user to work on a page ONLY after entering a value in a cell?
Is there a macro that will allow the user to work on a page ONLY after entering a value in a cell?
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
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks