View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Albert Browne Albert Browne is offline
external usenet poster
 
Posts: 9
Default Help with function

Hi.

I am using this call to a function to check if the workbook is open. In a
number of forms this works correctly.
In one form the function is not called. Looking in debug with a breakpoint
on the first line the code then jumps to line three without going to the
function. Can anyone suggest why this may be happening?


If WorkbookIsOpen("Ongoing") = False Then
Set wb = Workbooks.Open(ActiveWorkbook.Path & "\Ongoing")
Else
Set wb = Workbooks("Ongoing")
Workbooks("Ongoing").Activate
End If


Thanks,

Albert.