Macro for changing two shortcuts not running automatically on open in Personal Wkbk

[Vaslo]

Hello,

I have the following code to convert my < and > keys to increase/decrease decimal via my Personal Workbook. Upon opening, these should be active. I recently upgraded my pc and now when I open Excel I have to go out to the personal workbook and start the macro to get it to work. Is there a reason for this lack of start on open, or is there a better way to do this? Thanks. I have Excel 2013 64-bit.

Please Login or Register  to view this content.

[Greg M]

Hi there,

Have you tried moving your Personal workbook to:

Please Login or Register  to view this content.

Hope this helps - please let me know how you get on.

Regards,

Greg M

[Vaslo]

Thanks for your response. I did check and it is out in the folder you suggested. Even after starting with that file and then opening a blank file, it still is not working. Any other suggestions?

[Vaslo]

I even just tried a simple:

Private Sub Workbook_Open()
MsgBox ("TEST")
End Sub

And nothing.