Publishing my workbook to the internet

[martinargimon]

HI All,
I have published my workbook to the internet ( via the 'online' Excel version), although i am unable to see my ActiveX controls . Is there a way around it ??
Thanking you in advance
Regards
Martin Argimon (South Africa-Johannesburg)

 

[Fluff13]

Nope, ActiveX & VBA do not work with Xl online

 

[martinargimon]

HI Fluff13
Thanks for your confirmation
May i bother you once last bit to ask you to kindly look at this code below, as I cannot understand how to retrieve the address of the cell ( within this via code) and paste into another cell. ( The BOLD text ( comments) is not working )
Many Thanks
Kind regards

Private Sub CmdButAssignParcelBeneficiaries_Click()

Dim ParcelNo As Range
Dim DestinationRange As Range
 ' Dim CellAddress As Range

Sheets("SitePlan").Activate
Set ParcelNo = Application.InputBox(Prompt:="Choose cell to copy", Type:=8)
 ' CellAddress = ParcelNo.Address

Sheets("Beneficiaries_Burials").Activate
Set DestinationRange = Application.InputBox(Prompt:="Choose Destination cell", Type:=8)

ParcelNo.Copy DestinationRange
 ' CellAddress.Copy DestinationRange

End Sub

 

[Fluff13]

As this is a totally different question, you will need to start a new thread
Thanks

 

[martinargimon]

I will then
many Thanks and sorry
Rgds
martin