• 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:
  • How to assign a numerical value to a word in Excel

    I want to be able to select a material from a drop down list in column A, then type in the time in Column B and in a third column have the cost appear. What I need is to associate eg. VHS as having a rate card of £30. I can make lists and I can write the simple equation in the cost column to...

    Dontgetit105 pointsBadges:
  • While Loop in Excel VBA

    I have the basic loop and can not figure out what to write in the middle. I need to have row 9 column D populate a value from another sheet depending on the value in cell A9. Here is what I have so far: Private Sub Loop1() Dim myLoopCtr As Integer myLoopCtr = 0 While myLoopCtr <= 15 myLoopCtr =...

    Castaway19585 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:
  • Saving chart colors in excel 2003

    When I set chart colors in an Excel 2003 spreadsheet, save and reopen the spreadsheet, the color reverts to previous colors. I have tried creating a macro but this do not work. Can someone please advise me how to do this task?

    Kattydavis10 pointsBadges:
  • In Excel how to autofill a cell that references a list?

    I have defined a list. Now I am at the drop down on another sheet.  Instead of scrolling to the item in the list...  (a very long list), I would like to be able to start typing a few letters, and the lists shortens to just that initial input.  Much like a combo box can operate in VB.net. Any...

    Rdn5 pointsBadges:
  • vlookup

    how can I convert then match two lists of numbers?   One list has thousands of 7 digit numbers.   The other list is even longer, but contains all of the numbers in the first list, looking at the first 7 digits of each.   The difference is, the numbers have an additional digit on the end.

    Jkg5 pointsBadges:
  • Excel .xla slow to save

    I have a custom toolbar saved as an .xla.  Works great.  It has always taken about 1 - 2 min. to save the .xla.  But about two weeks ago the save time increased significantly. It now takes over 12 mins. to save.  Any ideas.  I haven't added much in the last month.  Tried rebooting machine. ...

    Smf170 pointsBadges:
  • Error message on startup of Excel 2003 workbook

    Could anyone tell me what the following error message means and how i could fix it? Cannot find XLQUERY.XLA!Register.DClick, which has been assigned to run each time [file name]key is opened. Continuing could cause errors. Cancel opening [file name]key?

    Cjones055 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:
  • Oracle Forms 6i – Export to Excel

    Hi All, I have an application on Oracle forms 6i, which is having 1 form to download reports in excel format. It works fine with excel 2003 but when require to work with excel 2010, it doesn't work. Please help me, please send your answer at - sachin81jain@yahoo.com

    Sachinjain5 pointsBadges:
  • Converting Oracle Report 6i into Excel

    the problem is in report the data is correct but when i try to convert into excell the dupicate rows are beuing formesd..i also did a page protect variation but report changes but not the converted file. if i have 50 records on page 1 then in report it shws 50 rows only but in xcel it shows 55 rows...

    Programmerjan35 pointsBadges:
  • Unlocking VBA project using VBA code

    Can i use vba code to unlock my x-cel vba project protected by password? I need to unprotect my project to add some code and then reprotect it.

    Yves69520 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:
  • Change fonts in drop down box created with autofilter in Excel 2003

    1. Is there a way to change the font size of the an auto filter drop down box?

    Mmppmm10 pointsBadges:
  • reformatting a multi-tab spreadsheet and access 2003

    Hi,    I have an instance where I have an Excl 2003 spreadsheet and need to reformat it into a single record format using the data from each of the tabs but I also need to put additional data into the new record. Here is another twist I want to be able to trigger this from my access 2003...

    Cwv19495 pointsBadges:
  • VBA Excel 2003 Copy and Paste

    I would like to know how am i going to copy a certain range (A1:E500) in File A and paste it in a different file (File B). Then copy a new range in other sheet of File A then paste it in File B without overlapping the data I copied from the first range. Thank you so much in advance!

    Eron09135 pointsBadges:
  • Edit-Find Excel 2003

    I prepared an Excel 2003 file containing about 10 spreadsheets for a company whose name appeared in the spreadsheets. The sheets contain confidential information about the company the file was sent to. I now wish to send this file to others having deleted the name of the original company for...

    RobSoros5 pointsBadges:
  • Excel 2007 freeze pane problem

    Dear Sir, Is there any method in Excel 2007 to enabling freeze pane option in protected Sheet of Excel 2003. Regards Furqan Ahmed

    Mobilink115 pointsBadges:
  • Pulling information from one spreadsheet into another spreadsheet.

    We have two spreadsheets created and spreadsheet b has referenced totals from certain columns from spreadsheet a. The problem is that the spreadsheets are maintaned by 2 different people. And throughout the day spreadsheet a gets new information added to it, how can this information be brought into...

    Jacketfan5 pointsBadges:

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