• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Publishing my workbook to the internet

martinargimon

New Member
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)
 

martinargimon

New Member
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

Code:
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
 
Last edited by a moderator:
Top