• How to lock Microsoft Excel macro

    I have a Microsoft Excel macro that needs to be sent to several different organizations but I don't want people seeing the source and they can't send it other people. How can I basically lock that macro? Thank you so much.

    ITKE434,585 pointsBadges:
  • How to find out which Microsoft Excel sheets have macros

    I have a Microsoft Excel workbook that has several sheets. These sheets have many macros inside of them too. But I can't figure out which sheets have them. The only way I found is to click on each of them using Project Explorer / VBA. Is there a better way to do this? Thank you.

    ITKE434,585 pointsBadges:
  • Making a macro in AS/400

    How to make a macro in AS/400?

    Ritug40 pointsBadges:
  • Microsoft Excel macro If Script

    I'm no macro expert, so I need a little helps with this. Here is what I am trying to do: If (2,36)="2C" then (2,37)="Physician" If (2,36)="1E" then (2,37)="nurse". Then I need to apply this to the whole column. so that if (3,36)="2C" then (3,37)="Physician" and so on down the column. What I am...

    PatrickKP5 pointsBadges:
  • Macros disappear when Excel closes

    Macros disappear once Excel is closed. Why is that?

    Lisa664020 pointsBadges:
  • Create macro on a shared system that will work on different computer

    How do you create a macro on a shared system that will work on different computers? We have a workbook on our shared drive. It is an Excel 2007 with several tabs with 2 pages each. I need to create a macro that will tell the entire workbook to print double sided when opened on other PCs.

    MotorSafety5 pointsBadges:
  • New to macros – extracting data

    Hello, I'm just learning how to use macros and have this fairly large project to do. It concerns extracting data from a schedule (timetable) with the courses, course code, name of tutor on it. I have managed to extract from a cell and have the following information come up in a message box (course...

    Oistins2610 pointsBadges:
  • Using macros in Microsoft Word

    How can I use macros in Microsoft Word?

    ashibitiya5 pointsBadges:
  • Excel and Access integration and auto-population

    Overall, I want to create a database that tracks defects for several sites and ouputs the information in a pivot table.  Each site (7 in total) documents their internal defect data and sends it to me weekly.  I then merge all of this data (have been doing so manually) into one spreadsheet to...

    Sm6hans25 pointsBadges:
  • Import text from another excel workbook

    I have a excel workbook (wb1) where the columns is showing the months and the rows is showing different actions that take place. If an action takes place in a specified month the cell corresponding to both the action and the month is marked yellow. In another workbook (wb2) I want to be able to...

    AenE15 pointsBadges:
  • Inserting pre-written parapgraph/sentences, phrases etc into a document

    I saw a Word file which did the following. There was a customized toolbar which popped up. You would place a cursor over the area you want the paragraph inserted, you click on a code letter/number and the paragraph would insrt into the desired location. I feel I'm word savy, i need to know where I...

    Drdreich5 pointsBadges:
  • MYOB open macro causes ‘macro disable’ messages when Office documents opened

    On a system that has MYOB installed every time a Office file is opened a message box appears saying that macros are disabled. I understand that the problem is due to the location that MYOB has used to store their macros. Can I move them and avoid this issue ?

    David995 pointsBadges:
  • How do I get a macro to move between workbooks?

    I have a template (workbook #1) that I would like to copy data out of and paste into the workbook that I run the macro from (workbooks 2, 3, 4, 5...). The problem is that when I record the macro from workbook, excel codes the name of that workbook, making the macro unusable in workbooks 3, 4, 5.......

    Bondsmith5 pointsBadges:
  • Why won’t the macro run in other worksheets?

    I want to make a table as part of a macro. The size of my document changes daily, so even though a choose control end before I make the table, it assigns specific cell numbers which it employs for subsequent runs of the macro. How to I get it to go to the last populated cell in a column...

    Felucha5 pointsBadges:
  • Can data in Excel 2003 be set up to automatically move from one sheet to another in a workbook?

    Is it possible to create a macro, or multiple macros to upon a button push move data from one sheet to another in the same workbook in Excel 2003? We have a workbook with three sheets, instead of having to manually copy and paste information once we have completed it from sheet one to the others we...

    Kaylee5 pointsBadges:
  • Batch file with keyboard commands

    I am trying to create a batch file that utilizes keyboard commands for a Macro on my computer, but I cannot figure out how. Any ideas would be appreciated. The command I am trying to run is alt+S.

    Jab81815 pointsBadges:
  • Auto Capture Macros

    Can Auto Capture Macro programs be detected?

    amdenson10 pointsBadges:
  • New and having a macro problem

    I have set up a simple budget and spending spreadsheet with separate sheets for each month. The sheets are basically the same, columns are the same, but the number of rows may vary. I need to set up a macro that will sort an individual sheet on 3 columns and be able to use it on any other sheet....

    DarbyBrown5 pointsBadges:
  • Email individual invoices

    I have macros in MS Access that email reports to groups of people. I am trying to work a way where I run a macro and it will send the specific report to each person. I have a list of 52 membership invoices that go out annually. Is there a way to get the query or macro to send the specific invoice...

    Greg655 pointsBadges:
  • VBA to copy sent email subject and to fields

    We use a Corel X5 macro along with Outlook 2007&2010 here to send or "export" drawings from our art dept to the sales dept. The macro creates an email with the attached sketch and subject line filled in. I need to modify it to save the current sent email, subject and "TO" fields to a text file....

    swinehart68031,050 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.

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

Following