none
How to Unlock a VBA Project that is locked? RRS feed

  • Question

  • Hi,

    Calling all Guru's out there!

    I have a spreedsheet which i have setup full now want to add macros to my workbook and apparently there already a couple macros in there. They are locked when i got VBA Editor everything is locked and asks for a password which I do not know.

    I have tried to use a hex editor and replace the string from "DPB=" TO "DPx=" which does not work because i have searched for this string in the file and it does not exist anywhere.

    Can someone please help me out.

    Cheers

    Thursday, May 2, 2013 6:27 AM

Answers

  • if you don't want to use the existing macro's; you could save as: spreadsheet without macro's and then add your own macro's. I'm no Guru, so this is the only option i know :)
    Saturday, May 4, 2013 4:14 PM
  • Open new file and copy using Shift and mouse button to select all sheets.

    Then Right click/copy to new workbook (or selected one).


    Oskar Shon, Office System MVP

    Press if Helpful; Answer when a problem solved

    Wednesday, May 8, 2013 7:40 PM
    Answerer

All replies

  • if you don't want to use the existing macro's; you could save as: spreadsheet without macro's and then add your own macro's. I'm no Guru, so this is the only option i know :)
    Saturday, May 4, 2013 4:14 PM
  • Sry. If you've code without access, you should connect with owner.

    Of course Pan Rik is a option, but you'll lose all existing VBA procedures.


    Oskar Shon, Office System MVP

    Press if Helpful; Answer when a problem solved

    Monday, May 6, 2013 10:01 AM
    Answerer
  • Even when i save as: spreedsheet without macros it maintain the VBA Password lock so i can not create any new macro's. How else can i work around this????

    lmoloney

    Tuesday, May 7, 2013 9:42 PM
  • Open new file and copy using Shift and mouse button to select all sheets.

    Then Right click/copy to new workbook (or selected one).


    Oskar Shon, Office System MVP

    Press if Helpful; Answer when a problem solved

    Wednesday, May 8, 2013 7:40 PM
    Answerer