Good Afternoon All,
I have a workbook made up of a separate sheet for each month. From the top of each sheet coming down page by page are itemised worklogs showing the days in the month on each row with columns showing the different job categories. The hours worked in each job category are shown for each day and totalled at the bottom of the page. Each client’s worklog takes up exactly one page. To the right of each page I have a command button marked “prepare for email “ which when clicked fires up a macro that copies that particular page into a new workbook and saves it to a prearranged folder ready to be emailed. My question is would it be possible to have residing on the toolbar just one macro which is able to tell which page to copy and move by the position of the cursor?(A1 for the first page, A46 for the second etc.
I have a workbook made up of a separate sheet for each month. From the top of each sheet coming down page by page are itemised worklogs showing the days in the month on each row with columns showing the different job categories. The hours worked in each job category are shown for each day and totalled at the bottom of the page. Each client’s worklog takes up exactly one page. To the right of each page I have a command button marked “prepare for email “ which when clicked fires up a macro that copies that particular page into a new workbook and saves it to a prearranged folder ready to be emailed. My question is would it be possible to have residing on the toolbar just one macro which is able to tell which page to copy and move by the position of the cursor?(A1 for the first page, A46 for the second etc.