I've been googling around and for the life of me I can't figure out how to programmatically discover if my end user has opened a spreadsheet in Excel or as an ActiveX object in IE. Some of the functionality in my sheet is not allowed to run in IE, so I would like to be able to detect this and disable certain buttons.

Any ideas?

I know you could find out if the spreadsheet is open at all in Excel but I' m not sure how to check whether a specific instance is open in Excel. Perhaps you can get the handle and compare that with the instance handle....

How accurate do you need to get?

pootle flump ur codings are working excelent.

How would someone open your spreadsheet in IE? If I type a path to an Excel Workbook in the Address bar or use the Browser Open command it still opens the file in the Excel Application.

Perhaps you can check the application name? Try.

?Application.Name
Microsoft Excel

If Not Application.Name = "Microsoft Excel" Then
Msgbox "Please open this workbook in the Excel Application." & vbcrlf & _
"Functionality is not available in IE Browser"
Exit Sub
End If

I havn't tested this... may not work within the browser. Just my first guess to check for this condition.

Dunno how Teddy's clients are doing it but try dragging an Excel file from a folder into an open IE window.

pootle flump ur codings are working excelent.

Did you crack this one Teddy?

pootle flump ur codings are working excelent.