Home > Unexpected Error > Unexpected Error 40230 Excel

Unexpected Error 40230 Excel

Press ALT+F11, choose the menu command Tools->VBAProject Properties, navigate to the Protection tab, and change the password but do not remove it (note the new password). Former boss asking me to do presentations more hot questions question feed lang-vb about us tour help blog chat data legal privacy policy work here advertising info mobile contact us feedback This apparently protects against a brute force attack. In excel file Review/Show Ink - I entered Alt+F11, It leads to a VBA Project window. http://centralpedia.com/unexpected-error/unexpected-error-40230.html

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

You should post questions like this to the MSDN Forums at http://forums.microsoft.com/msdn or the MSDN Newsgroups at http://www.microsoft.com/communities/newsgroups/en-us/. Join them; it only takes a minute: Sign up Access 2007: Unexpected error (40230) up vote 2 down vote favorite I am getting an Unexpected error (40230) when trying to access Open the VBE (view code) from the menu select Debug>> Compile...What happens if anything. This site requires Javascript to work, please enable Javascript in your browser or use a browser with Javascript support Repair Unexpected Error 40230 Excel Get Your Computer Running Normal Again in

Don't Worry - I'm here to help you fix it! Required fields are marked *Comment Name * Email * Website you MUST enable javascript to be able to comment Try these Add-ins! At this point, you'll have full reign over the VBA in the workbook. . The code window is then blank (ie no code!).

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?

  • erebus April 23, 2015 at 11:14 am The file that i am trying to open, is a Macro enabled excel file, i have saved it as xls as stated in the
  • Margie Says: at 4:48 AM easy just like it said.
  • From my understanding, the encryption behind modules is similar or the same as the document protection?
  • After fixing the registry, a quick scan with Spyhunter anti-malware tool will ensure that your PC has no more problems!
  • Theme by Colorlib Powered by WordPressDefault footer text Login with LinkedIN Or Log In Locally Email Password Remember Me Forgot Password?Register ENGINEERING.com Eng-Tips Forums Tek-Tips Forums Search Posts Find A
  • Compact then repair your DB, Tools> Database Utilities>> Compact Database and then Tools> Database Utilities>> Repair Database.

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.

After the enable VBA on the file, if the sheet or workbook is protected.

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.