A sheet has a drawpage, a draw page has a collection of database forms, a form can have form controls and subforms for database access. Buttons on a sheet are form controls.
Much better, more spreadsheet-ish:
- Code: Select all Expand viewCollapse view
=HYPERLINK("vnd.sun.star.script:Library.Module.MyURLTarget?language=Basic&location=user&row="&ROW(); "Push Me!") [together with some button-like cell style]
This "sheet button" can pass additional arguments to its macro (e.g. the row argument in the above example) and it can be copied like any other spreadsheet cell.
- Code: Select all Expand viewCollapse view
Sub MyURLTarget(sURL$)
nRow = getRowNumber(sURL)
... whatever ...
End Sub