I have a project that requires the user to print 5 charts from excel. I want to automate the process as follows:
The user downloads the excel file to their hard drive
The user opens the file
A message box appears on sheet 1 and says "click yes to print the 5 charts or cancel"
If the user cancels, the message box is erased and only sheet 1 is visisble
If the user clicks on "yes" then the 5 charts are printed and the message box is erased and only sheet 1 is visible
Bookmarks