I hate to admit that I am not keen with VB so cannot understand why this would appear. Cheers Excel Video Tutorials / Excel Dashboards Reports Reply With Quote July 4th, 2011 #6 jmdanmar View Profile View Forum Posts I agreed to these rules Join Date 4th July 2011 Loading Ozgrid Excel Help & Best Practices Forums
Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote Apr 19th, 2012,02:22 AM #2 Jerry Sullivan MrExcel MVPModerator Join Date Mar 2010 Location San Diego, California Posts 8,111 First Name Please enter a first name Last Name Please enter a last name Email We will never share this with anyone. If it works fine in this situation, try to disable add-ins in excel 2010. Share Share this post on Digg Del.icio.us Technorati Twitter Regards, Sandeep You can post sample data using any one of the following ways: 1.
Problem solved. From the file in question open the Visual Basic Editor (Alt + F11) 2. I've only installed it recently and only settings I have changed in excel is install the add-ins solver and data analysis. Microsoft Visual Basic Compile Error In Hidden Module Excel 2007 Then it should go ahead with Press OK .
Here’s Why. Compile Error In Hidden Module Thisworkbook Excel 2007 Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote Feb 12th, 2014,01:39 PM #8 Justaboo New Member Join Date Feb 2014 Posts 1 Re: Compile Error in Hidden This would display the following Disabled Items window using which you can see and also re-enable the disabled add-in. Providing high-quality answers to be a verified Q&A expert 2.
This happens either because there's been an upgrade or the file was used and saved in a different version of Excel by another user. Compile Error In Hidden Module Excel 2013 Windows 7 64 Bit Open Rounds Tracker. Note: Excel will create 2 new files (with the same names) in the folder, but they will not be corrupted. If it works fine in this situation, try to disable add-ins in excel 2010.
Click the View tab. Richard Schollar's HTML Maker 2. Compile Error In Hidden Module Thisworkbook Excel 2010 Sign in Share More Report Need to report the video? Compile Error In Hidden Module Thisworkbook Excel 2013 Am annoyed with this error...
For the Security update applied on 2012-08-14 and if you are using Office 2003 or Office 2007, refer to the instructions for your operating system: Windows XP or Windows 7 32-bit this content Alt-F11 to Open VB Editor Ctrl-R to Open the Project Explorer Pane if it is not already open Find the Icon in the tree structure under Book1 labeled "This WorkBook" and Repeat the steps above for each Windows User Account on the PC. Dinesh Kumar Takyar 754,620 views 17:20 INDEX & MATCH functions Beginner to Advanced 19 Examples (Excel VLOOKUP WEEK Video #3) - Duration: 1:09:43. Compile Error In Hidden Module Thisworkbook Excel 2010 Windows 7
I have recently uninstalled Nitro PDF5. You can select the ones you wish to re-enable and click the Enable button. All contents Copyright 1998-2016 by MrExcel Consulting. http://prcflow.com/compile-error/compile-error-in-hidden-module-thisworkbook.html If you have say, an older version of a macro and open it in a new version any method / function that does not have an origin will cause this exception
What could be the issue here? Compile Error In Hidden Module Excel 2010 This Error Commonly Occurs When Code Is Incompatible Ting Xiao 119,408 views 3:58 Biable y el mensaje: Error en el modulo oculto: ThisWorkbook - Duration: 8:34. 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
I really dont understand vba. I've hit through all the threads I could find, ripped up my manuals and everything else I could think of to locate why this is happening. Reply With Quote Apr 19th, 2012,03:04 AM #4 Trebor76 Board Regular Join Date Jul 2007 Location Sydney Posts 3,454 Re: Compile Error in Hidden Module: ThisWorkbook Hi Bambidear, Welcome to MrExcel!! Compile Error In Hidden Module Excel 2010 Windows 7 64 Bit For example, if the workbook contains ActiveX controls in forms and those files aren't on the client machine, you'll see this error.
Close Yeah, keep it Undo Close This video is unavailable. Here are the steps to restore the add-in's functionality: Close Excel Open a command prompt with admin privileges Run the following two commands: For 32-bit Windows: regsvr32 -u c:\windows\system32\mscomctl.ocx regsvr32 c:\windows\system32\mscomctl.ocx I press alt-f11 to get the vba console up and it seems like every workbook has a file called "thisworkbook" in it. Excel Video Tutorials / Excel Dashboards Reports Reply With Quote July 4th, 2011 #7 Reafidy View Profile View Forum Posts Administrator Join Date 8th December 2006 Location New Zealand Posts 4,201
See is these four steps fix the issue: 1. The time now is 11:50 PM. I have tried opening it with Excel 2003, 2007 and 2010 with the same problem. A:The rule for freezing rows and columns is...........
It should open without error. Rows and columns above and left of the selected cell will be frozen. This error occurs because 2 excel files are corrupt. Repeat the steps above for each Windows User Account on the PC.
Join the community of 500,000 technology professionals and ask your questions. If you're experiencing this upon opening a new Excel session, then there might be a problem with the template workbook you're using for new workbooks, or in Personal.xlsb. Delete all files in this folder that end with the extension .EXD. To stop the error from occurring: If in Windows XP open the following folder: C:\Documents and Settings\USERNAME\Application Data\Microsoft\Forms where USERNAME is the current user If in Windows 7 open the following