Compile Error In Hidden Workbook
Contents |
be down. Please try the request again. Your cache administrator is webmaster. Generated Thu, 06 Oct 2016 00:15:56 GMT by s_hv720 (squid/3.5.20)
Forums Excel Questions Compile Error in Hidden Module: ThisWorkbook Results 1 to 8 of 8 Compile Error in Hidden Module: ThisWorkbookThis is a discussion on Compile Error in Hidden Module: ThisWorkbook within the Excel Questions forums, part of the compile error in hidden module sheet1 Question Forums category; Recently noticed every time I open Excel (2007) this error block showing compile error in hidden module: hstbarpublic up . I've hit through all the threads ... LinkBack LinkBack URL About LinkBacks Bookmark & Share Digg this Thread!Add Thread to compile error in hidden module word 2013 del.icio.usBookmark in TechnoratiTweet this thread Thread Tools Show Printable Version Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode Apr 18th, 2012,04:29 PM #1 Bambidear New Member Join Date Apr 2012 Posts 2 Compile Error http://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_other/compile-error-in-hidden-module-this-workbook/5da89258-34fa-4bcc-96bc-223787da6ada in Hidden Module: ThisWorkbook Recently noticed every time I open Excel (2007) this error block showing up . 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. I hate to admit that I am not keen with VB so cannot understand why this would appear. Suggestions please? Am desperate to get this sorted out. TIA! Share Share this post http://www.mrexcel.com/forum/excel-questions/629554-compile-error-hidden-module-thisworkbook.html 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 Re: Compile Error in Hidden Module: ThisWorkbook Hi and Welcome to the Board, I haven't seen that before, but I'd suggest you start by checking in the ThisWorkBook Code Module to see if there is any code there. You can get to it with these steps... 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 Double-Click it. 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. Do you experience this same problem when Excel is closed and you Open an existing workbook (from another user) by double-clicking on it? Share Share this post on Digg Del.icio.us Technorati Twitter Using Excel 2016 Reply With Quote Apr 19th, 2012,02:53 AM #3 Sandeep Warrier Board Regularmmmm Pizza Join Date Oct 2008 Location Mumbai, India Posts 2,672 Re: Compile Error in Hidden Module: ThisWorkbook Also, do you have any add-ins installed? Share Share this post on Digg Del.icio.us Technorati Twitter Regards, Sandeep You can post sample data using any
Find/Replace add-in for Excel has stopped working, displaying the following error message: The error appears to be http://www.codedawn.com/index/-compile-error-in-hidden-module-message-in-excel a side effect of a recent update released by Microsoft. I don't know the details of exactly why this broke the add-in, and I'm not sure if http://www.excelforum.com/showthread.php?t=361675 it's caused by a Windows update or a Microsoft Office update. However, after scouring the Internet for a while, I came across a solution. Here are compile error 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 For 64-bit Windows: regsvr32 -u c:\windows\syswow64\mscomctl.ocx regsvr32 c:\windows\syswow64\mscomctl.ocx Open ExcelUsually that solves the problem, although the same "Compile error in hidden module" error compile error in can sometimes be caused by corrupted Excel files. So if the above steps don't do the trick, there is one other possible solution you can try: Close Excel Open Windows Explorer In the Windows Explorer address bar, type %appdata%and press Enter In the resulting list of subfolders, find and open the Microsoft folder In the Microsoft folder, find and open the Forms subfolder In the Forms folder, rename or delete the following two files (if they are present): comctllib.exd mscomctllib.exd Open Excel (it will automatically recreate the aforementioned files as it needs them)Hope that helps! In : Excel add-ins Previous post: QuickMonth... Tags: regex find replace excel add-in compile error hidden module « Back to posts Please enable JavaScript to view the comments powered by Disqus. blog comments powered by Disqus Custom Search Categories Excel add-ins(2) Firefox add-ons(3) Icons(1) QMC(2) XUL(1) Subscribe to this blog Designed by Arcsin Make a Free Website with Yola.
Forum Microsoft Office Application Help - Excel Help forum Excel General Compile error in hidden module? To get replies by our experts at nominal charges, follow this link to buy points and post your thread in our Commercial Services forum! Here is the FAQ for this forum. + Reply to Thread Results 1 to 6 of 6 Compile error in hidden module? Thread Tools Show Printable Version Subscribe to this Thread… Mark this thread as solved… Rate This Thread Current Rating Excellent Good Average Bad Terrible Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 04-11-2005,11:06 AM #1 Mike Guest Compile error in hidden module? Hi everone, In a workbook I am using, everytime I try to open the file I am getting a "Microsoft Visual Basic" window saying: "Compile error in hidden module: This workbook" What does that mean and how can trace it? Regards, Mike Register To Reply 04-11-2005,11:06 AM #2 Don Guillett Guest Re: Compile error in hidden module? http://support.microsoft.com/default...b;en-us;307410 I suggest the latest version of reader. FAST . -- Don Guillett SalesAid Software donaldb@281.com "Mike"