Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 01-12-2015, 04:18 AM
Wries Wries is offline Subs not working - objects as <unknown> Windows 7 64bit Subs not working - objects as <unknown> Office 2007
Advanced Beginner
Subs not working - objects as <unknown>
 
Join Date: Jun 2009
Posts: 40
Wries is on a distinguished road
Default Subs not working - objects as <unknown>

Hello All,
to describe what i have done:

all xlsm files have been made in my work laptop (everything was working)

then i went to different office for several weeks and have been updating workbooks (pivot data and/or macros), they have been working on that machine and i have copied them to shared hard drive, my manager however wasnt able to run those macros
now i am back and none of those are working on laptop either

macros from modules are working
macros in excel objects (sheets) are not
many of the objects have been renamed (e.g. i have had 36 labels named based on their purpose, now they are named as Label1 till label36, many objects when you click on them in the object browser read "LabelActiveDuration as <unnamed>")
when i create a new sub within sheet it works
when running subs from sheets it returns "compile error: object library invalid or contains references to object definitions that could not be found"
another error: runtime error 32809



i assume all this is happening because of the <unknown> object definition, is there any way how i can search for all these occasions in object browser and fix them?

Thanks,
Peter
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Select objects tool not working veritas Word 12 08-18-2015 09:03 PM
Need "Section 1" numbering which is followed by 1.1 Chapter titles and 1.2.3 subs xmlgirl Word 1 02-26-2014 12:31 AM
Subs not working - objects as &lt;unknown&gt; Convert equation objects to inline objects sumjoh Word VBA 1 01-29-2013 08:38 PM
Font style is UNKNOWN durevcan Word 2 03-28-2012 09:33 AM
Subs not working - objects as &lt;unknown&gt; Unknown error 0x80040201 when sending kenwortn Outlook 1 02-07-2006 02:53 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:57 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft