Ok, so I need a macro that will activate caps lock on my keyboard that will work outside of excel. I already have a code that will work inside excel, but the thing is certain data on certain sheets when i submit to a program outside of excel needs to be Capped, while inside excel it does not. And because of how this program works (not my program) it must be typed manually. I don't wanna use the caps lock key on keyboard because of how fast paced the work environment is if I cap in the wrong spot i have to re-do everything again.... very complex and time consuming. I just want it to change over when on a certain form, and then deactivate after I leave said form.