Macro start cell

[Peeratz]

I have a simple problem, but can't seem to find the answer. I want buttons to run macros in the cells following the buttons. Macros by default run wherever you have the cursor. What code do I use to tell the macro to first place the cursor in the cell next to each button?

Thanks

 

[Peeratz]

Maybe I need to explain further since there haven't been any replies...

I set up a simple spreadsheet to use as an employee schedule. For every employee, I have 7 rows (Sun thru Sat) and the hours of the day as columns. I want to have a column in front of every day to blank out any hours if a person is going to be off. I inserted a "Vacation" button to run a macro to delete the cells to the right of the button (deleting any filled in hours). My macro simply deletes the data in the cells, but if my active cell is not the first hour cell, my macro will just delete data wherever my active cell happens to be. How do I tell my macro to make the cell just to the right of the "Vacation" button the active cell before deleting the data? Right now, the only thing I know to do is make a macro for each person for each day that specifies that days cells...this means several dozen macros!
Please help, I know there is any easy answer.

 

[VoG]

With a button from the Forms toolbar then maybe something like this

Sub Button1Click()
ActiveSheet.Buttons("Button 1").TopLeftCell.Offset(, 1).Select
End Sub

 

[Ruddles]

How about passing the cell address to the macro when you call it?

[I]workbookname[/I]!'[I]macroname address[/I]'

For example:-

Book1.xls!'Macro1 F6'

Then your macro will 'know' that the button you clicked sent "F6" to it.