Results 1 to 9 of 9

VBA Project Password Stripped when saving as .xlsx

Threaded View

DRoberts VBA Project Password Stripped... 08-11-2009, 11:05 AM
Richard Schollar Re: VBA Project Password... 08-11-2009, 11:08 AM
DRoberts Re: VBA Project Password... 08-11-2009, 11:13 AM
romperstomper Re: VBA Project Password... 08-11-2009, 11:19 AM
shg Re: VBA Project Password... 08-11-2009, 11:23 AM
royUK Re: VBA Project Password... 08-11-2009, 11:32 AM
shg Re: VBA Project Password... 08-11-2009, 11:37 AM
DRoberts Re: VBA Project Password... 08-11-2009, 11:39 AM
shg Re: VBA Project Password... 08-11-2009, 11:42 AM
  1. #1
    Registered User
    Join Date
    08-04-2009
    Location
    Maryland, US
    MS-Off Ver
    Excel 2003
    Posts
    5

    VBA Project Password Stripped when saving as .xlsx

    I have an excel file that is distributed within my organization. That file contains certain worksheets that the end-users do not need to see or make changes to, so in the VBA project, I change those files to "VeryHidden". Then I protect the workbook's VBA code by going to Tools->VBAProject- Project Properties-> Protection tab and adding a password. This worked great as it allowed all the other sheets to function as intended, but didn't allow the users to access the sheets that were hidden.

    However, we recently upgraded to Excel 2007, and the password protection is stripped whenever the file is saved with the extension .xlsx. I can save it as a "macro-enabled" file with the extension .xlsm, but all that needs to be done to remove the password is to save it with the .xlsx extension again. Is there something that can be done in Excel 2007 to protect VBA code, or am I doing something completely wrong?

    This is my first post here, so please let me know if I've done something wrong!
    Last edited by DRoberts; 08-11-2009 at 11:40 AM. Reason: solved

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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