M
Mat
I have a simple spreadsheet that has a button that opens up a dataform (an
add-in) to allow users to enter data.
The dataform when called uses ActiveCell and ActiveSheet to check some
ranges and for protection.
When running this through IE (called via a link on our intranet) it does not
appear that the global objects ActiveCell and ActiveSheet are being populated
and I get an object error 91 when trying to look at these.
If I open and use the sheet with excel this all works fine.
I thought that it might be a problem with the add-in dataform but even my
calling spreadsheet gets nothing when looking at ActiveCell
I have had some success by trying to fully qualify the path etc. but
ActiveCell is just not set however I try and get at it.
Has anybody encountered this? it looks like a bug to me.
Alternatively can you suggest another way of accessing/determining the
activecell of a sheet.
Thanks,
Mat
Some code:
add-in) to allow users to enter data.
The dataform when called uses ActiveCell and ActiveSheet to check some
ranges and for protection.
When running this through IE (called via a link on our intranet) it does not
appear that the global objects ActiveCell and ActiveSheet are being populated
and I get an object error 91 when trying to look at these.
If I open and use the sheet with excel this all works fine.
I thought that it might be a problem with the add-in dataform but even my
calling spreadsheet gets nothing when looking at ActiveCell
I have had some success by trying to fully qualify the path etc. but
ActiveCell is just not set however I try and get at it.
Has anybody encountered this? it looks like a bug to me.
Alternatively can you suggest another way of accessing/determining the
activecell of a sheet.
Thanks,
Mat
Some code: