command button

  • Thread starter Thread starter Mark
  • Start date Start date
M

Mark

I'm trying to link an Excel pivot table to an Access
switchboard form using a command button (at the bottom of
the pivot table worksheet) labeled "Return to Access."
Can anyone help? If code is required, could you please
include the syntax?. Thanks in advance.

Mark in Chicago
 
If you add a button with the code:
ActiveWorkbook.Close
you should return to the form in Access.

However, this will cause a macro warning to appear as the PivotTable
opens. It may be better to add a note to the worksheet, e.g. "To return
to Access, choose File > Close & Return to PivotTable Form"
 
Back
Top