![]() |
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