Adding Code to Excel

[StarPassing]

I am placing code in Excel from Access using Application.VBProject.VBComponents and all works well, but Excel pops a dialog box saying “This action will reset your project, proceed anyway?”.

I’ve tried DispalyAlerts=False and EnableEvents = True, but nothing works.

Any ideas?

 

[StarPassing]

Found it. I was deleting the Option Explicit statement before I poked-in my code. Thus, forcing a project reset.