Greetings,

Wonder if someone could point me in the right direction.

I have a blank Test Result document written in excel (macro enabled for imported graphics placement and printing as a pdf) and have it formatted so it prints correctly. [This a mirror image of the Master Word Document]

However as this is a master document and is copied by other members of the test team to run on their laptops, I have it password protected so they cannot enter any data except for where the results should go.

But.... no matter what I try to do, Page Break is always active and if a member of the team starts putting in extra page breaks, it messes up the whole pdf as the graphics can split over 2 pages, page numbering then is incorrect etc etc.

Is there any way that I can inhibit the page breaks unless the excel file is unlocked.

I have spent some time searching for a solution and unable to find exactly what I need.

Thanks in advance for any guidance,

Tony