Weaver
Well-known Member
- Joined
- Sep 10, 2008
- Messages
- 5,197
We have a custom sort routine activated by a double click
It used to sit in a module in each workbook, but I modified it to work from personal.xls. When I moved it to a .xla addin file it stopped, so I'm figuring that opening a .xls doesn't trigger the auto_open event. Is the case? If so, is there another way, if not, any idea what I'm doing wrong?
Cheers,
Code:
Sub Auto_Open()
On Error Resume Next
Application.OnDoubleClick = "AutoSort"
End Sub
It used to sit in a module in each workbook, but I modified it to work from personal.xls. When I moved it to a .xla addin file it stopped, so I'm figuring that opening a .xls doesn't trigger the auto_open event. Is the case? If so, is there another way, if not, any idea what I'm doing wrong?
Cheers,