rusty nail
New Member
- Joined
- Sep 23, 2009
- Messages
- 1
Environment: Excel 2003, IE7.0
I am having unexpected vba script errors when opening
a spreadsheet in a IE in readonly mode.
The code works correctly in readonly mode if opened outside of IE.
It also works correctly inside of IE if not in readonly mode.
Dim ws as Worksheet
Set ws = ActiveWorksheet
Throws error:
Run-time error '-2147221080(800401a8)
Method 'ActiveSheet' of object '_Workbook' failed
Dim ws as Worksheet
Set ws = ThisWorkbook.Worksheets(1)
Throws error:
Run-time error '-2147221080(800401a8)
Method 'Worksheets' of object '_Workbook' failed
What can I do to make to script work when readonly in IE?
I am having unexpected vba script errors when opening
a spreadsheet in a IE in readonly mode.
The code works correctly in readonly mode if opened outside of IE.
It also works correctly inside of IE if not in readonly mode.
Dim ws as Worksheet
Set ws = ActiveWorksheet
Throws error:
Run-time error '-2147221080(800401a8)
Method 'ActiveSheet' of object '_Workbook' failed
Dim ws as Worksheet
Set ws = ThisWorkbook.Worksheets(1)
Throws error:
Run-time error '-2147221080(800401a8)
Method 'Worksheets' of object '_Workbook' failed
What can I do to make to script work when readonly in IE?
