Closed Thread
Results 1 to 2 of 2

Remove password on save file as .xlsm

  1. #1
    Forum Contributor
    Join Date
    12-02-2008
    Location
    Brisbane
    MS-Off Ver
    2016
    Posts
    804

    Remove password on save file as .xlsm

    Hi

    The password protected .xlsm workbook is opened, the first time the user saves it is by running a macro which creates the file name from a number of ranges in the workbook.

    What code do I add and where to save it using the following code but remove the passord protection and save it as unprotected?

    Please Login or Register  to view this content.
    I'm sure it's pretty simple by changing the FileFormat line but I can't crack it.

    Thanks for all help.

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Remove password on save file as .xlsm

    Hello BRISBANEBOB,

    It was possible to save a protected workbook in the older versions of Excel and bypass the password to open the workbook. Now, you need the password to remove the password. Due to the forum rules, I am not at liberty to disclose any methods that would circumvent security of any kind nor allow other members to post information on how to do it. For that reason, this post will closed.
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 2
    Last Post: 04-02-2013, 02:34 PM
  2. Save file xls file as xlsm - macro won't run in xlsm workbook
    By captbluefin in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-07-2012, 11:39 AM
  3. Excel 2007 : xlsm with encryption (file password)
    By zbaba4 in forum Excel General
    Replies: 0
    Last Post: 07-30-2010, 12:17 AM
  4. Replies: 0
    Last Post: 04-26-2006, 10:25 PM

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