Hello,
I have Excel 2010 and I have a macro on each of six sheets in a workbook. The macro exports the contents of the sheet to a PDF file with a designated name and file location. The issue I'm having is that to get to each sheet to run each macro I have to go to a welcome screen, select a user name, and enter their password and then run the macro on that screen. This is time consuming and inelegant. I need another macro on the welcome screen which I can click to run all of the other macros. I thought about running another macro to go through each of the steps above but its far too much work for too little payoff.
Here is the code which resulted from each of the macro record sessions.
Please Login or Register to view this content.
Bookmarks