Results 1 to 2 of 2
Thread: Leaving a mark... (Ex2003)
2007-09-25, 22:32 #1
- Join Date
- Jul 2001
- Terneuzen, Netherlands
- Thanked 0 Times in 0 Posts
Leaving a mark... (Ex2003)
I've built a workbook with several sheets and macro's and all. I'm handing this over with unlocked VBA code (to allow for further developments); is there a way to leave my name somehow somewhere in the sheet or code in such a way that it cannot be removed but also in a way that doesn't interfere with normal operation...
I though about a workbook with a (secret) password with author info but that's too visible again...
I don't know what I really want but maybe there are some creative and out-of-the-box suggestions???
2007-09-25, 22:59 #2
- Join Date
- Mar 2002
- Thanked 30 Times in 30 Posts
Re: Leaving a mark... (Ex2003)
If you leave the VBA unprotected the next user can pretty much do anything, including removing whatever mark you left.
You could put info in a sheet whose Visible property you set to xlSheetVeryHidden. Such a sheet is not listed in Format | Sheet | Unhide, so a standard user won't see it. But anyone who activates the Visual Basic Editor can see that the sheet exists, and reset the Visible property.
You can put information in custom document properties (in File | Properties). But anyone can change these properties.
I fear that your wishes are contradictory...