Hello,
I'm using Excel to track the inventory of store locations and the store managers have to put in numbers for inventory received, sold, wasted and on hand every week. I'm looking for a way to have the sheet automatically lock so it can't be edited 2-3 days after the day they do the inventory. I don't want the cells to lock as soon as they put the numbers in so if they make mistakes they can fix it without having to call a district manager to unlock the sheet. I've tried a few methods that I found online but can't seem to get it to work. I'm starting from scratch on these vba codes since I don't know enough about it to know what I did wrong and how to fix it.
Thank you,
Hew
Bookmarks