Step 2: Save your Workbook as XLS and MAKE A BACKUP COPY If you're working with an XLSM file, you'll need to save it as an XLS. Press ALT+F11 and enter the new password. Red Flag This Post Please let us know here why this post is inappropriate. You will just have to open your excel file and run the macro and yooupi your file is not protected anymore. http://stackoverflow.com/questions/16847059/access-2007-unexpected-error-40230
open any hex editor tool search for "DPB", then change it to "DPx" save and open the file normally. Step 8: Save a Close your Newly Unprotected Workbook. Share it with others Twitter Linked In Google Reddit StumbleUpon Posting Permissions You may not post new threads You may not post replies You may not post attachments You may not http://www.mrexcel.com/forum/excel-questions/294296-visual-basic-unexpected-error-40230-a.html AB, right again.
Why cast an A-lister for Groot? could you please suggest further Manika August 10, 2015 at 4:20 pm It Worked!!! These Windows errors are easy to repair. Jurie July 23, 2015 at 9:32 am Hi Kira, How can I get my email to you?…I would love to try out your macro?
save the file zip it back, then rename it back to .xlsx For .XLSM found this way to go inside .XLSM zip file then replace the password hash with the password http://datapigtechnologies.com/blog/index.php/hack-into-password-protected-vba-projects/comment-page-1/ I'm not really into Hex Editors, so I couldn't tell you if it's good or bad. All rights reserved. Then save and close the hex edito and drag the .bin file back into the zip file and rename it back to .xlsm It works!
Be as descriptive as possible.3. http://centralpedia.com/unexpected-error/unexpected-error-336-excel.html Thank you! Thanks. It will pop-up error as "Unexpected error (40230)" The way to fix it is right click at any macro file in VBA window select "VBAProject Properties..." go to "protection" tab check
PM your email and will send it to you guys. But the problem is that i got symboles instead of letters, it is as if everything is decrypted. Sorry…whoever you are. http://centralpedia.com/unexpected-error/unexpected-error-40230-vba.html Any help is much much appreciated vba ms-access ms-access-2007 access-vba share|improve this question edited May 31 '13 at 7:29 Gord Thompson 56.9k74796 asked May 30 '13 at 22:44 user793468 1,455105191
Don't save the xlsm file to xls. Your Answer Solve Media New PuzzleSwitch to audio puzzleMore Information... © 2016 - 2017 All Rights Reserved Microsoft is a trademark of the Microsoft group of companies. Technical Description of System Error (for Experts only): Microsoft Windows [Version 5.2.4630] (C) Copyright 1985-2014 Microsoft Corp.
ReplyDeleteAdd commentLoad more... Upgrade your Citrix mainframe version of Office to 20072. Web|-- Other Microsoft ProductsPC|-- Network Issues|-- Q & A - Hardware|-- Q & A - Software|-- Q & A - Other PC|-- Virus + Security DiscussionUtterAccess Odds and Ends|-- General Chat|-- Your PC will run much smoother after this process is completed.
I am getting it when trying to open a worksheet that has ... Frank April 1, 2015 at 11:39 pm I noticed when doing this, when you go into the project properties and unlock it, the code modules would come up with that Unexpected jason de leon April 20, 2015 at 8:29 am Thanks for the great tutorial, i remove my ms access vba password that i forgot, more power. have a peek at these guys My company recently converted from XP to Vista and from Office 2003 to Office 2007, but they did not convert the Citrix Metaframe version of Office from 2003 to 2007.