Re: Workbook_BeforeClose

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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
.

Relevant Pages

  • Re: Mail.app, original and reply
    ... At present the click on the reply icon has the double action of closing ... main Mail window. ... Barry Margolin, barmar@xxxxxxxxxxxx ...
    (comp.sys.mac.apps)
  • Re: Outlook 2003 will not close
    ... the upper right X to close the program? ... Unless something is preventing Outlook from closing, clicking the Close icon will close it, not minimize it to the Notification Area. ...
    (microsoft.public.outlook)
  • Itunes wont run
    ... When i doule click the icon I get a ... message saying that it has encountered a problem and is closing down. ...
    (microsoft.public.windowsxp.music)
  • Re: VPC in Dock always ON
    ... there is no option for quit on the Dock Start Menu. ... referring to the Virtual PC application icon. ... Likely he's just closing ...
    (microsoft.public.mac.virtualpc)