Hello,

First I want to thank the forum for the many posts that helped me to achieve setting up the protect issues we were having with the conversion to 2007. It was tough finding the topics that were specific to the issue but I did get there because of the work by the people on this forum. A big thank you.

Now I have a situation where the print macro is shot. Used to be set up to print 3 specific sheets (2 copies of each). In 2003 it seemed to work fine. In 2007 it is not working well at all.

Here is what is happening first.

There are 3 sheets. Two of them are BOM sheets which means that the total lines involved will vary each time the sheet is used. Unfortunately it prints out everything in the sheet (including 4 pages of empty cells) each time.

I had found a topic that covered this but I can't find it again. There are just too many posts to try and go through. Now that I am on hour 2 trying to find this again I am at the point of starting this thread.

The second issue is that the boxes and such are skewed now. We will have the lines drawn in surrounding a set number of cells and when we print they are usually a lot bigger covering other cells. The same thing happens with Logos and such. Maybe this should be a different topic or I may be able to find it elsewhere. Thought I would mention it.

Any help or suggestions on this would be greatly appreciated!

Thank you,

Mike