Error Visual Basic Thisworkbook
Contents |
be down. Please try the request again. Your cache administrator is webmaster. Generated Thu, 13 Oct 2016 13:29:38 GMT by s_ac4 (squid/3.5.20)
for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Ask a Question Ask for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Expand Search Submit Close Search Login Join
Compile Error In Hidden Module Link
Today Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Experts Exchange > microsoft visual basic compile error in hidden module Questions > Compile Error in Hidden Module: This Workbook Want to Advertise Here? Solved Compile Error in Hidden Module: This Workbook Posted on 2012-01-15 compile error in hidden module word 2010 MS Applications MS Excel 1 Verified Solution 5 Comments 3,967 Views Last Modified: 2012-05-12 I have a client with an active Excel spread sheet that has been sent to me that when I open it with Excel I initially http://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_other/compile-error-in-hidden-module-this-workbook/5da89258-34fa-4bcc-96bc-223787da6ada get a security warning that says "Some active contect has been disabled" I click on options and tell it to "enable this content" and that is when I get a Microsoft Visual Basic Error "Compile error in hidden module: ThisWorkbook". I have tried opening it with Excel 2003, 2007 and 2010 with the same problem. Others that receive the same speadsheet tell that they are not having any problem with it. I have tried 3 different computers with different https://www.experts-exchange.com/questions/27537733/Compile-Error-in-Hidden-Module-This-Workbook.html OS and version of Excel. What am I doing wrong here? 0 Question by:waytron Facebook Twitter LinkedIn Google LVL 27 Active today Best Solution byGlenn Ray It sounds like you and others receiving this error may be missing some library files, or have outdated versions. For example, if the workbook contains ActiveX controls in forms and those files aren't Go to Solution 5 Comments LVL 23 Overall: Level 23 MS Excel 16 MS Applications 5 Message Active 3 days ago Expert Comment by:Michael742012-01-15 This can be caused by add-ins. Try starting excel in safe mode (hold ctrl while opening excel) and open the file from there. Michael 0 LVL 1 Overall: Level 1 Message Author Comment by:waytron2012-01-16 I wish it were that simple. But I still get the same error when I start excel in Safe mode. 0 LVL 27 Overall: Level 27 MS Excel 26 MS Applications 7 Message Active today Accepted Solution by:Glenn Ray2012-01-16 It sounds like you and others receiving this error may be missing some library files, or have outdated versions. For example, if the workbook contains ActiveX controls in forms and those files aren't on the client machine, you'll see this error. Or, if the application calls an Outlook event (ex., mailform) and the version is different, you might see an error. Compounding this is that the VBA project for this workbook is likely locked for viewing a
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn http://stackoverflow.com/questions/19861288/excel-vba-run-time-error-32809-trying-to-understand-it more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community https://www.add-ins.com/support/microsoft-visual-basis-error-400.htm Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Excel VBA Run-time Error '32809' - Trying to Understand compile error it up vote 13 down vote favorite 1 A colleague at work made some changes to one of our macro workbooks and now on my PC only I receive the dreaded Run-time Error '32809' when I attempt to run it. This latest version runs fine on his PC and another colleague's PC that we tested it on. The previous version runs fine on all of our PC's, all compile error in of which are running Excel 2010. The error is thrown when the macro attempts to Select the Worksheet index 1, named "Info". I know that Select/Activate is not required but am just working with this Workbook for now and am trying to work out why I alone would receive this error. I have tried: Reboot/Power Cycle Saving a Copy of the Workbook Cleaning out Temp Files with CCleaner Researching online Checking for ActiveX Controls (Uses Form Controls) All with no success. I then had a bit of a mess around in the immediate window and discovered that even a simple: Debug.Print ThisWorkbook.Worksheets(1).Name would throw the run-time error which lead me to believe that somehow that Worksheet had broke. I added a couple of events to the Worksheet including _Activate and _Change but none would fire even after confirming that: Application.EnableEvents = True I added a simple Test Sub as follows: Public Sub Test() Dim ws As Worksheet Dim sheetNum As Integer For Each ws In ThisWorkbook.Worksheets ws.Select ' Selects all Sheets Without Error Debug.Print ws.Name ' Prints All Worksheet Names Fine Next ws Set ws = ThisWorkbook.Worksheets(1) ws.Select ' Selects Sheet 1 Without Error ' Prints all but sheetNum = 1, Ru
Data add-ins Downloadable macro books Specialty add-ins Time Saving add-ins Our favorites Add-in Collections Productivity Suite Accounting Collection Business Analysis Collection Charting Collection Data Collection Macro Book Collection Risk Analysis Collection Time Saving Collection Software Download information Download purchased software Add-in improvements and upgrades Trial verisions Support Support How to contact us Top support questions What to do if add-in tabs or buttons do not appear Money back guarantee Ordering FAQ's Product FAQ's How to open and use our add-ins How to repair Microsoft Excel COM add-ins and why and how to remove How to stop Microsoft Excel From crashing Need more help? Let us connect computers Resources Excel problems solved by our add-Ins Excel and PC tips Excel and Office newsletters Excel and Office user groups Excel and Office training Links to other Excel sites Excel operating problems and solutions Company About Add-ins.com LLC How to contact us Policies Affiliate program License agreement View Cart Quantity Discounts Money back guarantee Microsoft Visual Basic Error 400 Some user will get a a dialog titled Microsoft Visual Basic and it contains only the number 400, like the following dialog: For users of our software, this error is typically caused by having the add-in file for the Spreadsheet Assistant for Excel 2003 installed as in add-in in Excel 2007 or Excel 2010. The cure is to un-install it and install the correct file. Click File or Office Button, Options, Add-ins, GO. Uncheck Spreadsheet Assistant. Click Browse, go to C:\program files (x86)\add-ins and select Spreadsheet Assistant 2007-2013.xla. If you are not using our software and get the above message, it means that your code is referring to something that does not exist or no longer exists. The cure is is to step through your code line by line until you find the offending statement. From it you will hopefully get the clue to solve. It could be referring to a variable that had been previously set to a range and then the workbook closed. Or trying to run a command in a workbook that does not exist (very difficult to do!) The cure for our users of the Spreadsheet Assistant who get a Microsoft Visual Basic 400 dialog is to do the following: Excel 2007: Open, click the round Office button, Excel Options, Add-ins, and Go (with manage excel addins selected) Excel 2010 Open, Click File, Options, Add-ins, and Go (with manage excel addins selected) both: Unclick the Spreadsheet Assistant in the Add-in dialog Do OK's and close and re-open Excel Repeat the above steps to redisplay the add-in dialog Click Browse, then My Computer, C Drive, Program fi