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 came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.

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,118,765
Messages
5,574,116
Members
412,572
Latest member
Chriszion
Top