View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
MVM MVM is offline
external usenet poster
 
Posts: 53
Default VBA project in Intranet

EXcel VBA gurus:
This project works fine when opened in excel.
But my pop up is giving problem when opened in intranet link.
on degbugging, showpopup fails.

-2147467259 Method 'ShowPopup' of object 'CommandBar' failed

------code ---
For Each bar In CommandBars
If bar.Name = "MyBar" Then
x = 1
Set myPopup = bar
Exit For
End If
Next bar

If x = 0 Then
Call CreateMyPopup
End If

myPopup.Enabled = True
myPopup.ShowPopup

------code ---

it works sometimes.

Thanks
MVM