vba reference

This is really messed up. Please help me with a workaround that works. I'm completely disabled. I have a workbook called Journal.xlsm and another workbook named TokenHandling.xlsm. TokenHandling.xlsm is stored on my OneDrive but I access it via my local OneDrive folder on my harddrive...

I have an excel file with VBA code. This file is saved on Dropbox. I open this file from multiple locations with different versions of Excel installed. I get Can't find Project error when running the code because the Excel Versions are different. How can I automatically update the Reference to...

Hi guys! I can't change/read any of my activeX combobox properties without getting an error. I can address and modify my combobox via this code: ActiveSheet.Shapes.Range(Array("My_Combobox_Name")).Select With Selection .ListFillRange = "MySheet!" & MyRange.Address .LinkedCell = "A1"...

Hi All, Is there a way to attach the VBA references on opening the workbook. The users of my workbook can be both excel 2003 users and excel 2010 users. I want my macro, when you open this specific workbook. Check the Application version and if the version is 2003, than attch Microsoft ActiveX...

I am having trouble running my macros that use a form with a calendar control built in Excel 2003. I am getting the reference error for two missing references: Missing: ctMeter OLE Custome Control module Location: C:\Windows\system32\ctMeter32.ocx Missing: ctGauge OLE Custom Control module...

Hi<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p> </o:p> I have a spreadsheet that uses a number of public functions from an add-in in cell formulas. These same public functions are also called in the macros of the spreadsheet and so the add-in is...