Detect if opened in web browser, not Excel

[IanDeaville]

Hi,

My company has a web system giving links to all our forms. My form has some functions which seem to be happier if they are run in a "proper" Excel instance, not from the broswer. Is there a way for the worksheet iteself to detect the application it is running within, and warn the user if it is inside a browser?

Thanks,
Ian

 

[Jaafar Tribak]

Not sure if this would work but you can try the two following Properties :

Application.UserControl
ThisWorkbook.IsInplace

They may return True or False depending on whether the worksheet is open in the webbrowser or not.