asked on Excel Add-in VB.net - determine if active workbook has macros
Hi
I have quite a complicated add-in the causes strange errors if i open Excel by opening
a .xlsm file. I need to determine if the ActiveWorkbook is a .xlsm file.
How do I do this?
Private Sub ThisAddIn_Startup() Handles Me.Startup
If Globals.ThisAddIn.Applicat
oAddInStartUp()
End If
End Sub
I have quite a complicated add-in the causes strange errors if i open Excel by opening
a .xlsm file. I need to determine if the ActiveWorkbook is a .xlsm file.
How do I do this?
Private Sub ThisAddIn_Startup() Handles Me.Startup
If Globals.ThisAddIn.Applicat
oAddInStartUp()
End If
End Sub
Microsoft ExcelVisual Basic.NET
Last Comment
Murray Brown
What happens with above code?
ASKER
If it is a .xlsm it doesn't load my add-in. I have to go into the Option Add-ins section and select COM Add-ins then re-check the box to make it available as the system unchecks this.
ASKER CERTIFIED SOLUTION
Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a questionASKER
Yes. Agreed
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck