Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Page 2 of 3 FirstFirst 1 2 3 LastLast
Results 11 to 20 of 23

Thread: Unprotecting VBA Project via VBA code to change code

  1. #11
    Join Date
    28th January 2003
    Location
    Solihull - England
    Posts
    8,676

    Re: Unprotecting VBA Project via VBA code to change code

    Quote Originally Posted by segran
    What are sendkeys, and how is it used?

    Thank you
    The basic advice given in this thread is NOT to use sendkeys

    It is not a reliable method of coding

    As Roy says, just type in the password.
    Kind Regards, Will Riley

    Web Presence:
    Personal: The Trouble With Data
    LinkedIn: Will Riley

  2. #12
    Join Date
    18th March 2005
    Posts
    3

    Re: Unprotecting VBA Project via VBA code to change code

    Quote Originally Posted by royUK
    If you know the password, then in THe VB Editor Tools menu, select
    VBAProjectProperties>Protection. Then delete the password and uncheck the "Lock Project for Viewing" box.
    Hi

    I have forgotten the password, hence I dont have access.Please help.
    Thank You

    Excel Video Tutorials / Excel Dashboards Reports


  3. #13
    Join Date
    26th January 2003
    Location
    UK
    Posts
    4,682

    Re: Unprotecting VBA Project via VBA code to change code

    Remember guys if You do not know the password(s) then You are truly stuck - do not ask for any advise on this subject as OzGrid will not offer any help or advice on 'cracking' or 'hacking' that just would not be OzGrid

    jiuk

    Excel Video Tutorials / Excel Dashboards Reports


  4. #14
    Join Date
    17th April 2006
    Posts
    4

    Re: Unprotecting VBA Project via VBA code to change code

    Hello all,

    I found another way to unlock a VBE project, without using SendKeys.
    I use Win32 API to find the correct windows and manipulate them.

    The joined zip contents the VB6 source code. It's an Word 2000 version, but you can easily adapt it to Excel and/or in VBA ...

    Don't forget to edit the MVBE.bas module to adapt it to your language (don't works if the windows caption are not correct).

    The code is well commented in bad english (like this post ). So, sorry in advance ...

    Have a fun
    Last edited by royUK; April 17th, 2006 at 16:06.

    Excel Video Tutorials / Excel Dashboards Reports


  5. #15
    Join Date
    26th January 2003
    Location
    Derbyshire,UK
    Posts
    17,467

    Re: Unprotecting VBA Project via VBA code to change code

    gg67

    I have deleted this attachment. You are clearly asked not to post Code or tools to break any passwords. In fact it is Rule number 1
    No requesting of help to break any passwords Questions asking to break Sheet Protection, Workbook Protection or VBE Protection will be deleted and could get you banned. Supplying code to enable this, will get you banned.
    I would suggest that you read rhe rules & stick to them if you want to continue to use the Forum
    Hope that Helps

    Roy

    For free Excel tools & articles visit my web site

    If I have helped you and you feel like putting your hand in your pocket please make a donation to Children in Need

    RoyUK's Web Site

    royUK's Database Form

    About me.

  6. #16
    Join Date
    17th April 2006
    Posts
    4

    Re: Unprotecting VBA Project via VBA code to change code

    Hi,

    It's a misunderstanding. My code don't break any password.
    It's just another way to define programmatically the password.


    Greetings
    Jérôme

    p.s.: i can reattach my source ?

    Excel Video Tutorials / Excel Dashboards Reports


  7. #17
    Join Date
    26th January 2003
    Location
    Derbyshire,UK
    Posts
    17,467

    Re: Unprotecting VBA Project via VBA code to change code

    Does the user need to know the Password to use your application?
    Hope that Helps

    Roy

    For free Excel tools & articles visit my web site

    If I have helped you and you feel like putting your hand in your pocket please make a donation to Children in Need

    RoyUK's Web Site

    royUK's Database Form

    About me.

  8. #18
    Join Date
    17th April 2006
    Posts
    4

    Re: Unprotecting VBA Project via VBA code to change code

    Does the user need to know the Password to use your application?
    Absolutely.
    It's just a more secure way than SendKeys method to set the VBA project password programmatically.

    greetings

    Excel Video Tutorials / Excel Dashboards Reports


  9. #19
    Join Date
    26th January 2003
    Location
    Derbyshire,UK
    Posts
    17,467

    Re: Unprotecting VBA Project via VBA code to change code

    providing it cannot be abused to crack passwords, then please attach again. I am sure you understand that we have to be careful.
    Hope that Helps

    Roy

    For free Excel tools & articles visit my web site

    If I have helped you and you feel like putting your hand in your pocket please make a donation to Children in Need

    RoyUK's Web Site

    royUK's Database Form

    About me.

  10. #20
    Join Date
    17th April 2006
    Posts
    4

    Re: Unprotecting VBA Project via VBA code to change code

    No problem, i understand

    Hello all,

    I found another way to unlock a VBE project, without using SendKeys.
    I use Win32 API to find the correct windows and manipulate them.

    The joined zip contents the VB6 source code. It's an Word 2000 version, but you can easily adapt it to Excel and/or in VBA ...

    Don't forget to edit the MVBE.bas module to adapt it to your language (don't works if the windows caption are not correct).

    The code is well commented in bad english (like this post ). So, sorry in advance ...

    Have a fun
    Attached Files. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros.

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Project 2007: Managed Code Add-in for Importing Tasks from Excel
    By Dave Hawley in forum Downloads (no questions)
    Replies: 0
    Last Post: November 29th, 2008, 14:41
  2. Distribute Macro Code Project
    By The Dutchman in forum EXCEL HELP
    Replies: 5
    Last Post: May 27th, 2008, 06:38
  3. Lock VBA Project With Code
    By mrfitness in forum EXCEL HELP
    Replies: 7
    Last Post: January 20th, 2008, 01:31
  4. UnProtection Code for VBA Project properties
    By DoubleB in forum EXCEL HELP
    Replies: 7
    Last Post: October 25th, 2004, 13:24

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
  •  
porno