Macro Ctrl+Shift shortcuts

[samcd87]

I have been using a workbook with approx 15 macros. They all have a Ctrl+Shift shortcut eg Ctrl+Shift+X

They’ve always worked with caps lock turned off. But now suddenly they all require caps lock to be on.

It’s not a massive problem, but the users of the workbook are used to having caps off so they’re running in to problems.

 

[JohnGow383]

I would just go through them again and redo them.
If you enter "b" in lowercase. You can execute the macro by pressing (Ctrl + "b"). If you enter "B" in uppercase you can execute the macro by pressing (Ctrl + Shift + "b").
You can add or change a short-cut key at any time.

I have been using a workbook with approx 15 macros. They all have a Ctrl+Shift shortcut eg Ctrl+Shift+X

They’ve always worked with caps lock turned off. But now suddenly they all require caps lock to be on.

It’s not a massive problem, but the users of the workbook are used to having caps off so they’re running in to problems

 

[samcd87]

I think it might be a Mac issue. People using Windows are not having any issue - but those on Mac have to be in Caps Lock.

I have been looking for a way to turn caps lock on every time shift or command or Ctrl is pressed - but struggling.

 

[JohnGow383]

Ah ok, sorry I'm not familiar with Mac, they do behave weirdly sometimes

I think it might be a Mac issue. People using Windows are not having any issue - but those on Mac have to be in Caps Lock.

I have been looking for a way to turn caps lock on every time shift or command or Ctrl is pressed - but struggling.

 

[samcd87]

Does anybody know if I can activate caps lock whenever Ctrl+Shift are pressed. This caps lock issue is really messing with the users of my workbook.