Forced Upper Case

[Andrew Turek]

I have a spreadsheet with a macro which runs automatically when I open it and makes the gridlines invisible, goes into full screen and the like; and a QUIT macro which reverses all that.

Are there lines I could add which would turn the Caps Lock key on and off. For reasons I won't go into I want to run the spreadsheet in capital letters.

Thanks, all.

[VBA Noob]

See if link helps

http://www.ozgrid.com/VBA/force-case-text.htm

VBA Noob

[royUK]

See this code

http://www.excel-it.com/Forum/viewtopic.php?t=546