Access VBA Code to create a toolbar in Excel

[RodgerDJr]

Hello all,

I have created an access database that I export a query into an Excel
worksheet and do a little formating and what not. Now I would like to do
two things to the workbook. I want to create a toolbar and then add two
buttons, one to sort the list by last name and another to sort it by room number. This is going to be used for down time procedure so I want it to be as easy to use for whom ever is going to be here at the time.

TIA,
Rodger

 

[Guus2005]

There is the hard way and there is the easy way. The hard way involves a lot of coding the easy way is this.

Create a spreadsheet with the toolbar and buttons you describe in place. This will be your template.

Open it and add data from Access to it. Save as a different filename. Done.

HTH