Several keyboard shortcuts not working

[CRHAAG]

I am completely flustered on this one. I was working in a sheet today and hit control+c like I always do to copy a cell and the next thing I new There was a different active cell and and several rows were hidden. I assumed it was a mistake on my part, but sure enough, every time I hit control+c it takes me to cell G40 and hides rows 41-55. Hitting control+s does something similar. Control+v still pastes.

I went into word and double checked that the editCopy keyboard shortcut is still set to control+c and it is. I cannot find other postings with this same problem. This is incredibly annoying. Any help would be appreciated.

 

[JoeMo]

Have you checked to see if there is a macro in your workbook that's been assigned the shortcut ctrl + c?

To do this with your workbook active press Alt + F8 keys. Select Thisworkbook from the 'Macro in:' dropdown menu, select the macros, if any, one at a time, in the list that appears and click the Options button to see if the macro has been assigned a shortcut key.

Here's a simple example macro you can add to a new workbook that will select A3 and Hide/Unhide rows 1 & 2 on the active sheet. After you install it, press Alt + F8, select the macro, press Options and assign the shortcut ctrl+c to run the macro.

Sub Test()
With ActiveSheet
    .Range("A3").Select
    .Rows("1:2").Hidden = Not .Rows("1:2").Hidden
End With

End Sub

 

[CRHAAG]

Have you checked to see if there is a macro in your workbook that's been assigned the shortcut ctrl + c?

To do this with your workbook active press Alt + F8 keys. Select Thisworkbook from the 'Macro in:' dropdown menu, select the macros, if any, one at a time, in the list that appears and click the Options button to see if the macro has been assigned a shortcut key.

Here's a simple example macro you can add to a new workbook that will select A3 and Hide/Unhide rows 1 & 2 on the active sheet. After you install it, press Alt + F8, select the macro, press Options and assign the shortcut ctrl+c to run the macro.

Sub Test()
With ActiveSheet
    .Range("A3").Select
    .Rows("1:2").Hidden = Not .Rows("1:2").Hidden
End With

End Sub

That did it!! Thanks

 

[JoeMo]

That did it!! Thanks

You are welcome - thanks for the reply.