Results 1 to 2 of 2
  1. #1
    5 Star Lounger
    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???


  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 28 Times in 28 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...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts