does anyone know of a macro that can be used for every program?
460236
Up-Up-Down-Down-Left-Right-Left-Right B, A, Start.\n\nIt works all throughout reality, all aspects of life.
1075938
This macro will create a random number that does not change, even when the sheet is recalculated. It prompts you for an upper limit, a lower limit and then for (integer or decimal).\n\nSub RandomNumber()\nupperLimit = InputBox("Enter Upper Limit")\nlowerLimit = InputBox("Enter Lower Limit")\nnudp = InputBox("Just hit OK for Integers or type D for decimals")\nIf UCase(nudp) = "D" Then\n   With Selection\n      .ClearContents\n      .NumberFormat = "#,##0.0000"\n   End With\n   For Each cell In Selection\n       cell.Value = Rnd() * (upperLimit - lowerLimit) + lowerLimit\n   Next cell\nElse\n   With Selection\n      .ClearContents\n      .NumberFormat = "#,##0"\n   End With\n   For Each cell In Selection\n       cell.Value = Int(Rnd() * (upperLimit - lowerLimit + 1) + lowerLimit)\n   Next cell\nEnd If\nEnd Sub
991232
You can use a VBA sub with a very simple "Select Case" construct to define color depending on the value.\n\nAdd the following macro to your personal workbook (Alt-F11, right click the Personal Workbook in the VBA project window and select "add module" then paste the snippet of code in the main VBA window)\n\nWhen you want to implement the formatting, just select the range that needs to be conditionnaly formatted and execute the macro.\n\nAs it is, the macro evaluates a cell value and give to its immediate neighbour on the right the associated color. If you want to change the relative positions between evaluated cell and formatted cell, just change the values in all the Offset() of the code. The first argument is the row difference and the second the column difference.\n\nThere is no limit in the number of conditions you can use, just add more "Case" statements mimicking the syntax used here to increase the granularity of your conditionnal formatting.\n\n\n\n\nSub ColorCoding()\n\nDim rngCell As Range\n\nFor Each rngCell In Selection\n\nrngCell.Offset(0, 1).Interior.ColorIndex = xlNone\n\nIf IsNumeric(rngCell.Value) And Len(rngCell) > 0 Then\n    Select Case rngCell.Value\n        Case Is > 4\n            rngCell.Offset(0, 1).Interior.Color = vbBlue\n        Case 3 To 4\n            rngCell.Offset(0, 1).Interior.Color = vbRed\n        Case 2 To 3\n            rngCell.Offset(0, 1).Interior.Color = vbYellow\n        Case 0 To 2\n            rngCell.Offset(0, 1).Interior.Color = RGB(255, 140, 0)\n    End Select\n\nEnd If\n\nNext rngCell\n\nEnd Sub
891123
pctools programs\n\n:>peace
985632
One of the easiest ways is to use the Macro Recorder\nClick Tools, Macro, Record new Macro. Then do the stuff you want to automate. Then click the small square on the Record box to stop recording.\nGo back to Tools, Macro and click Macros (ALT + F8) This will show you the macro code that was recorded.  You can modify it or add new code.\n\nA helpful website for beginners is here:\nhttp://www.angelfire.com/biz7/julian_s/julian/julians_macros.htm\n\nMore in depth go here\nhttp://www.exceltip.com/category.html#6
1038128
Yes there is a way to do this, but you'll have to split the master document up into about 4 spreadsheets.  There's only one good way of doing this if you don't want to spend years matching these together and that is with a macro.  The problem is that macros take a descent little bit of expertise to develop.  So it's time for me to give you a crash course in macros.  First you need to make sure that your security level in Excel for macros is set to Medium or Low.  From the menu bar, go to Tools, Macro, Security.  Reset it to Medium save the file, then restart Excel.  Excel needs to be restarted for the change to take effect.  Now on to creating macros.  Go to Tools, Macro, Record New Macro.  Pick a name for your macro then click OK.  Don't do anything whatsoever to the Excel workbook, just click the stop button.  This creates basically a blank macro named Macro1 or whatever you called it in your workbook.  Now we want to go edit that macro.  Go to Tools, Macro, Macros.  \n\nNow select your macro and click Edit.  Now past the following text in as macro code:\n\n'Set column A to your part number and column B to your lead time\nFor Each x In [Doc2! A:A]           'Looks through every cell in column A in a worksheet called Doc2\n    If x.FormulaR1C1 = "" Then      'Tells computer to end the search if it reaches\n        Exit For                    'a blank cell in column A of Doc2\n    End If\n    \n    For Each y In [Doc1! A:A]       'Looks through every cell in column A in a worksheet called Doc1\n        If y.FormulaR1C1 = "" Then  'Tells computer to go to the next part number in Doc2 if it reaches\n            Exit For                'a blank cell in column A of Doc1\n        End If\n        \n        If x.FormulaR1C1 = y.FormulaR1C1 Then           'Compares the part numbers to see if they match\n            x.Offset(0, 1).Value = y.Offset(0, 1).Value 'Sets column B in Doc2 equal to column B in Doc1 (your lead times)\n            Exit For                                    'Moves to next part number in Doc2\n        End If\n    Next y  'Moves to next part number in Doc1\nNext x      'Moves to next part number in Doc2\n\n\nEverything after an apostrophe is comments and will appear green.  This will have no affect on how the macro runs.  You will need to modify the macro or you worksheets so the macro works properly.  The code gets pasted between the Sub Macroname and End Sub portions.  The comments I listed should help you understand how the macro works.  Here's something REALLY IMPORTANT!!!  Save your workbook BEFORE you run the macro.  You can't undo what a macro does by hitting the undo button.  So if it doesn't do what you want, simply close the file without saving it.\n\nContact me, I probably need to explain a few more things too you.  Since your master list is over one spreadsheet long there are going to be some complications you'll have to work through that could make it very difficult, even for a macro.  \n\nMacros can save hours or days of time, but they can be difficult to a new user.  The Visual Basic 6 Blackbook by Coriolis is a good reference guide if you want to learn to write macros in Excel.  Just remember the coding may be a little different in Excel than for writing a program in VB6.
864078
Not unless you are using a macro program.
47128
Start, Programs, MS Office, Word
981152
Select a cell then F2\n\nVBAXLMan
379357
It is called "extention".\n\nSo, you need an extension list.\nOne of them (very wide) is attached. You can obtain there an alphabetically list of extensions as well as associated extentions with some program.
674311
Don't know if this will help, but you can print only the odd or even pages.  See the print dialog box.\n\nYou could probably record a keystroke macro that start from the top of the last odd page, select all text on that page, delete it, skip to the top of the page twice (thus landing at the top of the next odd page), and repeat itself.  Run it on a copy of the file!!!\n\nIf someone around you knows VB, you definitely could get them to write a simple macro.
534942
There are macro programs - search under 'macro' - which will allow you to do a key sequence for regular tasks.  Or you can learn VBA if you need to do it within Office applications (and for free:))
514166
"RUN AWAY!  RUN AWAY!"\n\nMonty Python. . .Holy Grail
1174415
if you use windows xp click \n\nstart > set program access and defaults
618409
http://www.presentersonline.com/tutorials/powerpoint/macros.shtml
138684
make a right clic on top of  file and clic open with and then select bloc note ( if you're using other type of window like 98 then let shift press and then make a right clic on top of the file
882802
On the Tools menu, click Customize, and then click the Commands tab.\n\n\nIn the Categories box, click a category "file" in the command box click and hold the "send now" and drag it to the displayed toolbar and release the button.\nDrag the command or macro you want from the Commands box to the displayed toolbar. \nIf you don't see the command "send now"  under file, click All Commands in the Categories box. and find "send now" button in the commands box\n\nTip   To quickly add a built-in button to a built-in toolbar, click More Buttons  on a docked toolbar, (or click the arrow  in the upper-left corner of a floating toolbar), click Add or Remove Buttons and then select the check box next to the button you want to add.