Push Button Properties

[Bpgasguy]

I created a push Button to assign a macro. I have created the buton and asigned the macro and tried the button nothing worked so i wanted to edit the button but cannot get to the properties of the button

Thank you

[Ratslinger]

Hello,
Not specific as to the button used. If this is a control on a form are you in design mode?
Get there from Form Controls toolbar:

[Bpgasguy]

recorded macro to refresh pivot table nothing happens assigned it to mouse press

sub Main
rem ----------------------------------------------------------------------
rem define variables
dim document as object
dim dispatcher as object
rem ----------------------------------------------------------------------
rem get access to the document
document = ThisComponent.CurrentController.Frame
dispatcher = createUnoService(“com.sun.star.frame.DispatchHelper”)

rem ----------------------------------------------------------------------
dim args1(0) as new com.sun.star.beans.PropertyValue
args1(0).Name = “ToPoint”
args1(0).Value = “$F$8”

dispatcher.executeDispatch(document, “.uno:GoToCell”, “”, 0, args1())

rem ----------------------------------------------------------------------
dispatcher.executeDispatch(document, “.uno:RecalcPivotTable”, “”, 0, Array())

rem ----------------------------------------------------------------------
dim args3(0) as new com.sun.star.beans.PropertyValue
args3(0).Name = “ToPoint”
args3(0).Value = “$D$1”

dispatcher.executeDispatch(document, “.uno:GoToCell”, “”, 0, args3())

end sub

[Ratslinger]

Not overly familiar with Pivot Tables but my use shows a range selected before the Recalc:

	args9(0).Name = "ToPoint"
	args9(0).Value = "$B$3:$G$25"
	dispatcher.executeDispatch(document, ".uno:GoToCell", "", 0, args9())
	dispatcher.executeDispatch(document, ".uno:RecalcPivotTable", "", 0, Array())

.
You show only one cell - $F$8

[Bpgasguy]

just have to be in the pivot table