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: