Hi I have a spreadsheet with various code and I am trying to lock certain parts of the spreadsheet to ensure nothing gets changed by accident. However when i drop down a menu (part of a VLOOKUP function) it come up with the error in the subject line and point the 'debug' as below:
Runtime Error 1004.JPG
Bookmarks