+ Reply to Thread
Results 1 to 4 of 4

modify password protected xls document

  1. #1
    Registered User
    Join Date
    11-25-2008
    Location
    NYC
    Posts
    8

    modify password protected xls document

    Hi All

    I want to lock my template in a way that the macro i run will be able
    add or delete rows to the template but no one will be able to modify the first 3 rows
    and other things related to the template such as header and footer.
    in addition i dont want to save the macro within the xls document.
    when i use SaveAs method it saves the new file with the macro
    editable.

    Thanx

  2. #2
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200
    Place the code in an Exel addin, *.xla then itwon't actually be in the template.
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  3. #3
    Registered User
    Join Date
    11-25-2008
    Location
    NYC
    Posts
    8
    Hi

    what you mean by putting the code in xla document?
    do you mean rename my template from xls to xla?
    if i do so excel appears visible.and the code is transferred to the destination
    file.

  4. #4
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200
    Google "create excel addin"

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1