creating a macro for printing

g48dd · 06-07-2009, 07:39 PM

I don't know if this is even possible. I am working with excel 2003. I get a workbook sent to me via Email that has 12 tabs on it and each tab has to be printed out. The fastest way that I know, to get this done is start with tab 1; hit alt+f, u, alt+f, enter, Ctrl+P, enter, Ctrl+page down ( to move to next tab and do it all over again), each tab is a slightly different width so I am constantly have to use "Fit to Page" but each tab will fit on one page easy.

I was wondering can I use a key stroke macro to print this workbook. I actually get 5 workbooks like this every night, it does not really take that long, maybe I am just being lazy, I was thinking that I might be able to use a key stroke macro and then name it for what ever workbook it works with (workbook 1 print ) but I don't no if this will work or if there is an easier way to get the printing job done.

I can't upload the workbook but I could create a simple say 5 tab workbook that has no data in but has same formatting and upload that if you need to see what I am doing.

Thanks Ken

**mudraker** · 06-07-2009, 07:55 PM

Record a macro whislt formatting & printing your books

g48dd · 06-08-2009, 02:27 PM

Hi Mudraker, I am not sure I understand what you are saying, I always do a search before I post. I must admit some of my searches are not so hot. I was sure this had to have been answered before; actually I know you can create a key stroke macro to print I have done it, what I don't know is can it be done for a report that gets sent to you not one created in your own Excel. I guess I do not really understand how excel macros work I was thinking for it to work with a certain workbook, that workbook would have to be created by me? I think that is what I was asking .... in which case I am guilty of not naming my question correctly

. The problem I was thinking would be that the report that comes in has a different date and sometime a different name so I thought that would be a problem. I did check to see if I had posted this question before because I have wanted to for some time, when I do a search on my posts I can see that I have not. However when I do a search on macros and printing this is what I get:

Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 71 bytes) in /home/eforum/public_html/search.php on line 1155

I don't know what that means and that is why I posted anyway, I am sorry if I have posted something that has already been answered, I don't think that I have Cross Posted

Thanks
Ken