Hi Steve,
Welcome to the Microsoft Community.
We take your question very seriously. A word of caution though, Excel 2007 is no longer supported and we do not have this version of Excel on our tests for testing and reproducing issues, so our familiarity with this version as support staff is limited.
That said, we will keep this thread open so that other community members can offer you advice and assistance. There are many experienced users in the community who may know more about Excel 2007 and are willing to share their solutions.
Thank you for your understanding and cooperation.
May you have a great day!
Best regards,
Ian - MSFT | Microsoft Community Support Specialist