1
  • Remove macros from Microsoft Excel 2003 workbook

    I am wondering if there is an easy way to remove macros from an Excel 2003 workbook. Several of our users have had emails with Excel attachments rejected due to the macros they contain.

    Iamabadger35 pointsBadges:
  • Microsoft Excel 2003 Macro to stop workbooks from becoming inactive

    I have an shared Excel workbook that has a macro for auto save (update), The problem users are having is while working on different excel workbooks not linked to the shared workbook, when the auto save starts on the shared workbook all other excel workbooks become inactive until the auto save is...

    Danielm5520 pointsBadges:
  • Macro using Visual Basic

    Using Visual Basic, I need to choose XYZ information in a cell, in Excel, and another cell must give me ABC predetermined information. How should I do that?

    JoyStrassacapa25 pointsBadges:
  • Excel 2003 Macros with Org Chart Parent

    Hello, I have a corporate org chart for which I am trying to write a macro. The Excel workbook is set up so that each company is in a unique cell. The subsidiary is one column to the right. For instance, I would like to return the values in the far right column for the data below. Thank you. COL  ...

    Vanillathunderrr5 pointsBadges:
  • Message Alert Box in Excel 2003

    I have a two files, one is the consolidated time monitoring and the other file is the individual time monitoring. The individual time monitoring file has 30 sheets which is the name of each agent and in shared mode. On that file, agents are responsible to provide/indicate the things that they've...

    Eron09135 pointsBadges:
  • VBA macro to search macros in workbooks

    I have an Excel macro that will search folders for .xls workbooks and can open them. Now I need to search the macros for any reference to a unc path. How do I search a macro?  

    Smf170 pointsBadges:
  • Getting rid of multiple macro copies in Excel 2003

    Somehow, in Excel 2003 I have 4 copies of the same macro on the toolbar (not sure how that happened).  However, when I click on Tools>Macro>Macros, there are no macros shown, and all options are grayed out except Cancel.  When I go to Tools>Add-ins, one copy of the macro is shown, and it...

    Rerics595 pointsBadges:
  • Missing reference to Microsoft Office 11 Object Library

    Using MS Office Excel 2003 on XP I have written a number of macros that use the following code, With Application.FileDialog(msoFileDialogFilePicker).... Something (?) has happened and now this portion doesn't work any longer.  When clicking on the macro I get the error variable not defined with...

    Smf170 pointsBadges:
  • Horizontal to vertical

    how do you change a horizontal excel 2003 spreadsheet with qty breaks to a vertical speadsheet with quantitiy break or is there a marco

    Mike5010 pointsBadges:
  • Excel 2003 Help: How to delete duplicates from specific colums and criteria

    Hi I have already sent my question here: http://www.vbforums.com/showthread.php?p=3477514#post3477514 But I will ask the same again: In my Excel file I have several columns and lots of rows. I want the macro to check the column named REF (let say it's in the B column). And it will check if other...

    Groom5 pointsBadges:
  • I am getting “compiler error in hidden module” error in Excel 2003 while running Macro

    I am getting :"compiler error in hidden module " error in EXCEL 2003 only while running MACRO. Actully this MACRO is running on some PCs & for some PCs it is showing that error. The installation of MS EXCEL 2003 is same on all PCs. Please help me ASAP. Thanks in advance !

    Shirishbidarkar5 pointsBadges:
  • Excel macro between worksheets

    I have an Excel Workbook with a "Paid" sheet and an "Outstanding" sheet, both sheets have a File Number column. I would like to create a macro that looks through the "Outstanding" sheet and if the File Number from the "Outstanding" sheet is also in the "Paid" sheet can the entire row be deleted...

    Adavidson5 pointsBadges:
1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following