Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problems with Excel via IE
Hi All,
I believe others have encountered this problem but I have not seen a resolution.... I am serving up an Spreadsheet via our content management system, thus the spreadsheet is loaded via IE rather than Excel itself. A button on the sheet calls an add-in (the Jwalk dataform): Private Sub cmdEnterData_Click() Application.Run "dataform2.xla!showdataform" End Sub Upon entry to the form I am getting an object error 91 on the Activesheet Object: If ActiveSheet.ProtectContents Then MsgBox "This command cannot be used on a protected worksheet." & vbCrLf & "Use the Tools - Protection - Unprotect Sheet command and try again.", vbCritical, APPNAME Exit Sub End If This would, however, work if I ran it through the Excel full client. The same problem also affects Activecell. It looks to me that these global objects (Activesheet, ActiveCell etc) are not being set by IE. The problem is not with the Add-in as referencing Activesheet from the calling sheet gets the same error. Hope someone can help, Mat |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
aauugghhh...#div/o problems & various average formula problems | Excel Worksheet Functions | |||
Excel 2003 drawing objects problems in Excel 2007... | Excel Discussion (Misc queries) | |||
Problems when using macro created in Excel 2000, in Excel 2003 | Excel Programming | |||
Problems using Excel 2000 to open/save file saved in Excel 2003 | Excel Discussion (Misc queries) | |||
Problems merging an excel file due to code or file problems? | Excel Programming |