View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.programming
NickHK NickHK is offline
external usenet poster
 
Posts: 4,391
Default Application close problem

Tempy
So if you put a button on a worksheet in your Recon_Master.xls, with this
code:

Private Sub CommandButton1_Click()
MsgBox Application.Workbooks.Count
End Sub

What value do you see ?

NickHK


"Tempy" wrote in message
...
If i look at my task manager it shows me 2 instances of excel running.

1. Microsft Excel - Recon_Master.xls (my doc with code)
a. Personal.xls
b. Recon_Master.xls
2. Microsoft Excel - Book1


Tempy

*** Sent via Developersdex http://www.developersdex.com ***