Hi,
I have been working on this VBA code which lets me to lock a cell after data input. I tried on test and it was working but as soon as I copied it to the production file it stopped working. I am really lost why it isn't working.
File has conditional formatting.
Code:
Please Login or Register to view this content.
UPDATE
Issue is with conditional formatting. It doesn't work on those cells
Last edited by Whooops; 01-16-2020 at 10:16 AM.
The cell being marked as locked is what the sheet protection is enabling. The cells of a sheet are marked as locked when created and the user has to mark them as unlocked to enable editing when a sheet is protected.
What doesn't kill you is just biding it's time
But the thing is I have another xlsm file that runs same code and no issue there. I input my data -> Cell locked -> Input data to another cell -> Cell locked. That works fine on other file but on this I can't achieve that
Hi,
Sheets start out with all cells locked. You probably have to initialize the Sheet with the following code or equivalent before entering data for the first time:
LewisPlease Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks