ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How to activate add-ins for particular files?? (https://www.excelbanter.com/excel-programming/342528-how-activate-add-ins-particular-files.html)

kewlrunnings

How to activate add-ins for particular files??
 
I created an add-in for a userform to be prompted when any excel file opens.
I wanted to know if there is away to have this userform prompted only for
excel files in a particular folder??? Thank you in advance!

Dave Peterson

How to activate add-ins for particular files??
 
Maybe you could just check the path of the workbook?

If LCase(ActiveWorkbook.Path) < LCase("c:\my documents") Then
Exit Sub
End If



kewlrunnings wrote:

I created an add-in for a userform to be prompted when any excel file opens.
I wanted to know if there is away to have this userform prompted only for
excel files in a particular folder??? Thank you in advance!


--

Dave Peterson


All times are GMT +1. The time now is 01:47 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com