VBA Code To Lock Cells upon Opening File

I have a code (Shared Below), that locks a few different ranges of cells without protecting the entire sheet. My workbook has numerous sheets, and I am currently working on "Sheet 9". My objective is to lock these specific ranges of cells without protecting the entire sheet (sheet protection limits too many things for what I'm trying to do). I would also like for the VBA code to run automatically everytime the file is opened. Currently, my code only works by closing out of the VBA, clicking onto another sheet and then going back to "Sheet 9" to activate the sheet. I do not want for someone using the file to have to manually run the VBA to lock the specific cells. Any help will be greatly appreciated! Thank you!

Please Login or Register  to view this content.

Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #2 requires code tags. I have added them for you this time because you are a new member. --6StringJazzer