tonyenglish
New Member
- Joined
- Sep 23, 2009
- Messages
- 13
Hi folks I've hit an issue with some VBA. To make things really simple I've put together a really basic spreadsheet. In the Workbook_open event I have a msgbox that consists of msgbox "Events Enabled = " & application.EnableEvents to show the events status and a line to set it to true. This bit of code runs as I can see the popup show and it says that the events are enabled.
I have a beforeDoubleClick event set on a cell in the worksheet and an Active X button on the worksheet. All they do is show a message box. Neither of these work. But if I put a Form based button on the worksheet that works fine.
So does anybody know why I can't get the active x and events to fire off even though my VBA is running and enabling events?
It works fine on my PC, just not on some that I email it to.
I have a beforeDoubleClick event set on a cell in the worksheet and an Active X button on the worksheet. All they do is show a message box. Neither of these work. But if I put a Form based button on the worksheet that works fine.
So does anybody know why I can't get the active x and events to fire off even though my VBA is running and enabling events?
It works fine on my PC, just not on some that I email it to.