I would like to set up a workbook with the first spreadsheet containing a
series of commandbuttons, set into a calendar, that enables the user to print
out information contained in other spreadsheets.
I can set up the commandbutton to do this for one spreadsheet but as there
will be many different prints this would mean many different spreadsheets.
I wanted to know that if I created several named areas in one spreadsheet
whether I could get the commandbutton to print off a named area using the
commandbutton macro. Or is there another solution?