Make logo permanent in Excel with protected sheets

tinaaho
tinaaho used Ask the Experts™
on
We have an Excel workbook which we give clients the ability to unprotect the sheets and modify when they need to.  The workbook is branded with the client's logo, which currently is a JPG. We have not found a way to make the JPG permanent, which runs the risk that this workbook will be available to non-clients. Is there a way that we can allow them to unprotect the sheet but not edit/delete the logo?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Whatever protection you apply in excel, there are always ways to break into it. Your scenario is worse. It provides for "unlocking". So be assured that even casual users of the sheet (not power users) would be able to play with the logo.

Saqib

Author

Commented:
How about a VB macro that each time the user tried to print, that it inserted the original logo; or put a footer stating Property of: xxxx? The VB code protected with different password. Is that type of VB code possible upon a print command?
Although the VBA protection is more difficult to protect it can always be broken into by a serious programmer.
CompTIA Network+

Prepare for the CompTIA Network+ exam by learning how to troubleshoot, configure, and manage both wired and wireless networks.

more difficult to protect

should have been

more difficult to crack

Author

Commented:
I'm not so worried about a serious programmer, just the client's general staff taking with them to a new employer or emailing to peers.

Author

Commented:
so it is possible to have VB written that would do this and can the VB be required to be enabled to view or print the form?

Author

Commented:
Perfect solution. Thank you.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial