I've a spreadsheet with a sheet or two for each month of the year. The idea is the user has a menu page and using that sends them to the correct start sheet using just one macro so that the sheet can grow without doing a macro for each additional month. So the months are listed in column B and the buttons are in column C. I started with the first month to see if I could get it to work using a message box to show me it worked as expected. The code was:
So that gave me the correct row and cell. A bit of further coding and it was selecting the correct sheet. So I copied the shape and pasted it into the other rows.
ON testing it then gave me the row of the first picture. If I deleted that it then gave me the number of the one now at the top, no matter which button I click on. I'm at a loss. ANyone got any ideas? TIA
Bookmarks