Hi,
I have a spreadsheet that is linked to an Access database. I have created a
macro that will update or sync the sheet with the database. I want to make
it so a user can just click a button to run that macro. I have the button
on the sheet, but I'm not sure how to make it run the macro. Please Help.

Thanks,
Dan

Dan,

If you placed the button on the sheet and it didn't prompt you for the
name of the macro, you probably used a button from the
Controls Toolbox.

Right click on the button and select "View Code"
You'll be taken to the "Click" event for that button.
Just place the name of your macro between the Sub.. and End Sub.

Or....delete that button and select one from the "Forms" toolbar.
As soon as you create the button, you'll be prompted for the
macro to assign to it

John

"Dan B" wrote in message
...
Hi,
I have a spreadsheet that is linked to an Access database. I have created
a
macro that will update or sync the sheet with the database. I want to
make
it so a user can just click a button to run that macro. I have the button
on the sheet, but I'm not sure how to make it run the macro. Please Help.

Thanks,
Dan

Perfect....Thanks!!



"John Wilson" wrote in message
...
Dan,

If you placed the button on the sheet and it didn't prompt you for the
name of the macro, you probably used a button from the
Controls Toolbox.

Right click on the button and select "View Code"
You'll be taken to the "Click" event for that button.
Just place the name of your macro between the Sub.. and End Sub.

Or....delete that button and select one from the "Forms" toolbar.
As soon as you create the button, you'll be prompted for the
macro to assign to it

John

"Dan B" wrote in message
...
Hi,
I have a spreadsheet that is linked to an Access database. I have
created
a
macro that will update or sync the sheet with the database. I want to
make
it so a user can just click a button to run that macro. I have the
button
on the sheet, but I'm not sure how to make it run the macro. Please
Help.

Thanks,
Dan

Dan,

Happy to have been a help.
Thanks for posting back.

John

"Dan B" wrote in message
...
Perfect....Thanks!!



"John Wilson" wrote in message
...
Dan,

If you placed the button on the sheet and it didn't prompt you for the
name of the macro, you probably used a button from the
Controls Toolbox.

Right click on the button and select "View Code"
You'll be taken to the "Click" event for that button.
Just place the name of your macro between the Sub.. and End Sub.

Or....delete that button and select one from the "Forms" toolbar.
As soon as you create the button, you'll be prompted for the
macro to assign to it

John

"Dan B" wrote in message
...
Hi,
I have a spreadsheet that is linked to an Access database. I have
created
a
macro that will update or sync the sheet with the database. I want to
make
it so a user can just click a button to run that macro. I have the
button
on the sheet, but I'm not sure how to make it run the macro. Please
Help.

Thanks,
Dan