Keyboard Shortcuts Not Working In Workbook

t0ny84

Board Regular
Joined
Jul 6, 2020
Messages
118
Office Version
  1. 365
  2. 2016
  3. 2013
Platform
  1. Windows
  2. Mobile
  3. Web
Hi,

I was wondering if someone might be able to assist, I added some Always On Top Code from this MrExcel Post Link. Whilst it works perfectly I have noticed since adding it that I can no longer use keyboard shortcuts e.g. Control C and Control V. It is only on this workbook and no others, I tried removing the code but the issue still is there. Does anyone know if the code in this thread would stop keyboard shortcuts or another reason there might be as to why the keyboard shortcuts aren't working in one workbook?

Thanks in Advance,

t0ny84
 

Some videos you may like

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.

t0ny84

Board Regular
Joined
Jul 6, 2020
Messages
118
Office Version
  1. 365
  2. 2016
  3. 2013
Platform
  1. Windows
  2. Mobile
  3. Web
I found my culprit (code below), each time I would change cells it would call my user form so it actually meant that the cell in the workbook wasn't selected but the user form. Deleted it and it now seems to work! :)

VBA Code:
'Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Range)
'Call userform1_show
'End Sub
 

Watch MrExcel Video

Forum statistics

Threads
1,119,237
Messages
5,576,899
Members
412,753
Latest member
Coach_Olson
Top