Get message about Book2 when saving Workspace

I am using Excel 2003, File, Save Workspace for the first time.
I get asked "Do you want to save the changes you made to Book2?" even though I have no Book2 in the list of open files.

 Message about Book2 List of Open Files
LVL 1
Alex CampbellAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
dlmilleConnect With a Mentor Commented:
The code in the attachment, is below.

Hope this helps!

Dave
Sub InformAllOpenXLS()
Dim myWorkbook As Workbook

    For Each myWorkbook In Application.Workbooks
        Debug.Print myWorkbook.Name, "Visible? " & Windows(myWorkbook.Name).Visible
        
        If Windows(myWorkbook.Name).Visible = False Then
            xmsg = MsgBox("Open Workbook " & i & ": " & myWorkbook.Name & " - Visble? " & Windows(myWorkbook.Name).Visible & "   Hit OK to make it Visible, Cancel to Ignore", vbOKCancel, "THIS WORKBOOK IS NOT VISIBLE - HIT OK to Make VISIBLE")
            If xmsg = vbOK Then
                Windows(myWorkbook.Name).Visible = True
            End If
        Else
            xmsg = MsgBox("Open Workbook " & i & ": " & myWorkbook.Name & " - Visble? " & Windows(myWorkbook.Name).Visible, vbOKOnly, "THIS WORKBOOK IS VISIBLE")
        End If
    Next myWorkbook
End Sub

Open in new window

0
 
FernandoFernandesCommented:
this is not the list of open files... the list of open files is under the Window menu, not the file menu.

can you please put on a picture of the Window menu ? and the VBA, please ! (Alt+F11)

Thanks,
0
 
FernandoFernandesCommented:
wops... sorry... I just saw that you did it right already... my bad, ....
0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
Alex CampbellAuthor Commented:
I created three sample spreadsheets A, B, C and then a sample workspace ABC.
When I open ABC, it tells me there is a Book3 spreadsheet already open.


A.xls
0
 
Alex CampbellAuthor Commented:
0
 
Alex CampbellAuthor Commented:
0
 
Alex CampbellAuthor Commented:
0
 
Alex CampbellAuthor Commented:
0
 
Alex CampbellAuthor Commented:
0
 
Alex CampbellAuthor Commented:
0
 
dlmilleCommented:
Re: Your 34897327 comment and picture.  What happens when you select "Unhide"?

Dave
0
 
dlmilleCommented:
I was able to create a workspace with the 3 files and then open that workspace with no problem.  Check your XLSTART folder to see if some file isn't loading hidden inadvertently.  When you unhide, do you see other workbooks there?

Run this macro (attached) and let me know the results

it simple macro to enumerate all open workbooks and identify any that are not visible with capability to change visible to TRUE

Dave
InformOpenXLS.xls
0
 
TommySzalapskiCommented:
In http:34897327 and http:34897350, the screenshots you posted show the 'unhide' button as active in the Window menu. This usually means there are hidden workbooks. Try clicking it and see what happens.
0
 
TommySzalapskiCommented:
Oops. Forgot to reload before posting.
0
 
dlmilleCommented:
Same thing I asked in 34918871 post...

That's why I wrote that macro...

:)

Dave
0
 
Alex CampbellAuthor Commented:
Thanks for the macro. Will try to run in the next hour or so, but it might be tomorrow morning. It is 3:50PM right now.
0
 
dlmilleCommented:
@Tommy - no worries :)

Dave
0
 
Alex CampbellAuthor Commented:
The problem seemed to go away by itself since the Unhide choice does not appear.  But, now I have the the macro to use if it appears again.
0
All Courses

From novice to tech pro — start learning today.