ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   VBA project in Intranet (https://www.excelbanter.com/excel-programming/322174-vba-project-intranet.html)

MVM

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


All times are GMT +1. The time now is 01:40 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com