Problem with autostart workbook

[Sacruzsa]

Hello everyone,

I have a problem with a form that I wrote in excel. Normally the form starts when opening the file, but when the program is closed and I open it again 1min later, the form does not start automatically anymore, then excel opens with I have to use the button I initially created to use the start the form back , the weird thing is that when you close it again and reopen it the form starts automatically
I've been working on this for over a week now and can't find a solution for this, my first thought was because the file is on a ShP server but if I save it locally, the problem persists

I used the following code in 'ThisWorkbook'
Private sub workbook_open()
Application.visable = False
frm_Address_Book.show
End sub

Anyone have an idea where the error is?

 

[cmowla]

This is probably not your issue, but when this kind of thing happened to me in the past, it was because I was using lines of code that typically speed up Excel. Specifically,

Application.EnableEvents = False

When Excel is restarted, this is changed to True, but if you would forget to have one of the subroutines not also execute:

Application.EnableEvents = True

(with EVERY venue for which the subroutine can possibly terminate), there is a chance there is a "leak".

But that is just one possibility, of course.

 

[Sacruzsa]

Hi cmowla,

When I use your solution, excel opens every time, that's just what I don't want
The intention is that only the form appears and not Excel, for this I have provided a button that is protected

 

[Sacruzsa]

I found the solution , apparently the excel did not close correctly and kept running somewhere in the background , I added a terminate code at the end and now it works perfectly