I'VE NEVER USED THE SENDKEYS METHOD BEFORE AND I'M HAVING A BIT OF A
PROBLEM.

All I want is for the computer to put the CapsLock on when a certain
workbook is activated, and then to turn off the CapsLock when the book
is deactivated; why doesn't the below work?

Private Sub Workbook_Activate()
Application.SendKeys "{CAPSLOCK}", True
End Sub

Private Sub Workbook_Deactivate()
Application.SendKeys "%{CAPSLOCK}", True
End Sub

Any help greatly appreciated

Jason