I have in two files the same code for event:

Private Sub Workbook_BeforeClose(Cancel As Boolean)

...

and I when I have open both files...and when I click in icon to they will
close EXcela (this sharp) mistake appears.

Surely therefore that in every file are the same variables ... (..loops).

I know that I can close the first first and then second file but doesn't
there be no some trick??

I'm confused about what icon you're clicking.

Are you just closing one workbook or are you closing the excel application?

In any case, you didn't share the error that appears.



Andrzej wrote:

I have in two files the same code for event:

Private Sub Workbook_BeforeClose(Cancel As Boolean)

..

and I when I have open both files...and when I click in icon to they will
close EXcela (this sharp) mistake appears.

Surely therefore that in every file are the same variables ... (..loops).

I know that I can close the first first and then second file but doesn't
there be no some trick??

--

Dave Peterson