Hi,
I have no idea how to write VBA but I do know how to do a key stroke macro to print and save it in a personal worksheet that opens when I open excel 2003. I have recorded a macro that prints a workbook that is emailed to me, it works for all 5 workbooks which are all different in the number of tabs in each workbook. I recorded a separate macro for each workbook because each one has to have the "fit to page" done to the tab before it can be printed. Each macro works fine except for 1, when I try to run the macro it makes no difference weather I use the short cut key assigned or run it from the macro window (alt+F8), it get this:
Run-time error '1004'; Select method of Worksheet class failed
I really don't understand too much about macros, I no how to unhide the personal macro workbook where this macro is at. When I look at the book I see a blank sheet but the macros are available. When I get the error I get the choice to DEBUG if I do that it opens a new screen for me; I guess to step through it. I am guessing that someone needs me to copy and paste the code here so you can see it? Or can you already guess what the problem is?
Thanks
Ken
Bookmarks