window locking after opening another workbook...

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
 
J

JLGWhiz

Probably need to put an extra line in your button code to activate the
welcome sheet again.
 
M

Mr. m0le

ok... thats what I was thinking but just wasn't sure if it would of been
something else.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Set as Default Template not working 0
How can I force a workbook to close? 6
Run code from another workbook 7
populate a combobox based on unique values in another workbook 16
Text in note pane of "normal" display suddenly much larger 1
How do I set focus (and select text) on a text box on a modeless userform? 0
Cell values to an array, then array transpose to another workbook 8
Use a master workbook to carry over changes to multiple workbooks 1

Top