I know it is bad practice but I have little choice but to use SendKeys in the situation I am in.
I have a master program where I am running a loop through several other sheets where I import code into its vba editor. This part works fine. But I want to add a step where it then protects each sheet by locking its project for viewing. But when I run throguh the code, it tries to protect the master program and not each individual sheet.
How can I tell it to protect the other sheets? It this possible?