Trying to update a checkbox in excel, but from Access VBA

[ShiftyJaffa]

Hi,

I'm trying to update some Checkboxes which are in an Excel sheet, but I'm trying to do it from VBA in a public sub I have created in an Access Module.

I have linked the Excel sheet and can change the cells using queries, but this will not change the checkboxes. I'm running Access 97 and am looking for some code to open the Excel sheet (preferably hidden) and change the check box at runtime, is this possible?

Thanks in advance for any help