Fred Kestler
Posts: 2
Joined: 2011-01-05
|
I have the following code snippet in the AddinModule.vb file:
Private Sub adxExcelEvents_WorkbookBeforeSave(ByVal sender As System.Object, ByVal e As AddinExpress.MSO.ADXHostBeforeSaveEventArgs) Handles adxExcelEvents.WorkbookBeforeSave
e.Cancel = True
MsgBox("test 2")
End Sub
For some reason, when I hit the save button in Excel this code does not get initiated. Does anyone have any ideas?
Thanks. |
|
Eugene Astafiev
Guest
|
Hi Fred,
I have just tried to reproduce the issue on my PC. It works as expected on my PC with Excel 2007 SP2. Please make sure that your add-in is loaded by the host application.
I have a bunch of questions:
1. What version and build number of Add-in Express do you use?
2. Excel version and SP number?
3. Did you installed the latest service packs for Office and .net?
4. Could you please show me the adxloader.log file (typically it is located in the <My Documents>\Add-in Express folder)?
And the last question: Did you register the add-in before? |
|
Fred Kestler
Posts: 2
Joined: 2011-01-05
|
Eugene,
Thanks for your reply. I decided to take a different approach and added a Ribbon bar instead. It works perfectly. Great tool.
Regards,
Fred |
|