How to turn caps lock on automatically on starting/loading a worksheet

[ronakinuk]

Hi,
I have a worksheet, that I want users to put data only in capitals.

I have mentioned many times to those people to make sure they put this in capitals.

they keep forgetting and later i need to change all.

can a macro turn caps lock on as soon as the worksheet is loaded.

thanks

[Guido Geurs]

dear,

This works for me (see attachment)
BUT I must call the macro two times on openning and closing (not much of a problem but still ???).

This macro also reset the caps lock in the original state after closing the Excelsheet.

I hope this will help You.

br,