Excel VBA general issue, don't know why and how to solve

[mr2bart]

Hi All,

I have a general issue with Excel files with VBA that I have developped.

After a variable usage time of my files, I have no more access to some menu (like change cell color), even sometimes excel windows becomes completly blank and I have no choice to close excel window and re-open it.

I wonder if on my VBA code, I need to add something to stop completly the VBA process. I use a lot of forms. I use this way to make them appear and disappear, I suspect maybe something missing:

Private Sub UserForm_Activate() Form_export_io.Repaint
Call export_IO
Unload Form_export_io
End Sub

It happen more often when I work with my files with VBA and other files are opened and I switch for one to another.
Maybe something special to do in VBA?

Thanks for help!!!
PBA

 

[mr2bart]

Hi All,

I got it ! So I explain, it may be usefull for you all.
In fact I have some VBA process which modify some cells in hidden row or column and finish the process at this position without coming back to non-hidden area.
So I add on VBA to move back active cell on this non-hidden area, and no more trouble.

Thanks!