window locking after opening another workbook...

  • Thread starter Thread starter Mr. m0le
  • Start date Start date
M

Mr. m0le

I'm not completly sure if this is an actual focus issue or what but here is
my problem...

I have a welcome page so to speak that has buttons that open other workbooks
for different purposes. Everything opens fine without problems. My issue is
that after whichever workbook is closed, I have to either click or alt-tab to
a different window (other than excel) then back to the welcome page so that
the welcome page can be used again. Is this just a matter of adding focus
code into the workbooks when they close back to the welcome page or is it
something else.

I'm also using this in the BeforClose section of each workbook to bypass the
save question.

Private Sub Workbook_BeforeClose(Cancel As Boolean)
ThisWorkbook.Saved = True
ThisWorkbook.Close
End Sub
 
Probably need to put an extra line in your button code to activate the
welcome sheet again.
 
ok... thats what I was thinking but just wasn't sure if it would of been
something else.
 
Back
Top