A macro code to check whether any workbook is currently open or not.

abhay_547 · #1 (**permalink**) 04-11-10, 07:29

Hi All,

I have created some toolbars for essbase connection. I won't a macro which will check whether there is any workbook which currently open or not. If there is no workbook open then macro should have code line which will show a message to the user that there is no workbook currently open and he can't run a macro. I have got a macro which check whether a particular workbook is open or not but it becomes specific because i will have to mention the name of the workbook. I want a macro code which will check whether any workbook is open or not. Please expedite. Thanks a lot for your help in advance.

Colin Legg · #2 (**permalink**) 04-11-10, 09:15

Hi,

I think the first thing I would try is:

Code:

    If ActiveWorkbook Is Nothing Then
 
        MsgBox "No workbook currently active"
 
    End If

I suggest this rather than checking Workbooks.Count in case a user has Personal.xls

Have a play around with it to see if there are any caveats?

Hope that helps...

abhay_547 · #3 (**permalink**) 04-11-10, 09:21

Thanks a lot. It's working now.

Internet Services

Web Development

Digital Marketing

Consumer Tech