Make logo permanent in Excel with protected sheets
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?
Last Comment
ASKER
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.
more difficult to protect
should have been
more difficult to crack
should have been
more difficult to crack
ASKER
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.
ASKER
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?
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Perfect solution. Thank you.
Microsoft Excel
Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.
144K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
Saqib