How do you assign a macro to a command button in Excel 07?
Q. Ok, I have recorded a macro and created an activeX control button in excel. Now I want to assign the macro to be executed when I click on the button.
Asked by t f - Wed Jan 28 00:37:03 2009 - - 2 Answers - 0 Comments

A. After adding the button on the sheet, right click on it choose view code, Put the name of the macro(say macro1() is your macro) in like the following Private Sub CommandButton1_Click() macro1 End Sub Hope this helps.
Answered by AQuestionMark - Wed Jan 28 00:55:44 2009

How can I use a macro to paste information into a table?
Q. I know that you can record a macro in Excel, and it works simply to copy and paste. But because its a table, I need to insert a new row each time the data is pasted in. Its a bit like a database on Excel. Each time this means all the rows below it have to move down one, and I just can't do it! I've never used the visual basic editor and don't have a clue how to actually write macros. Can anyone help?
Asked by Ash - Thu Apr 23 18:36:47 2009 - - 1 Answers - 0 Comments

A. Here is a simple macro to insert a new row 12, each time it is activated, and select cell A1 in the new row. You can modify the row number, copy the code lines, and insert into your copy and paste macro. Sub InsertRow() Rows("12:12").Select Selection.Insert Shift:=xlDown Range("A12").Select End Sub
Answered by garbo7441 - Thu Apr 23 20:46:32 2009

What is the difference between a macro lens and a telephoto lens?
Q. Is it possible to take macro shots with a telephoto lens? I can't decide whether to get a macro lens or a telephoto lens. My current lens is 18-55mm.
Asked by Rachael G - Mon Oct 22 14:38:50 2007 - - 6 Answers - 1 Comments

A. :) Exactly Macro is for very close up shots you want to see in great detail. A Telephoto lens is for farther away shots, like landscapes or events. That is for zooming. Sounds like you have a canon kit lens there...I would upgrade depending on the type of photography your doing. Visit for more help on deciding what is right for you.
Answered by Triple Threat - Mon Oct 22 14:49:41 2007

How do you create a macro in excel 2007 to view a table in another worksheet?
Q. I need help on creating a macro to view a table, chart, and form from different worksheets in the same workbook.
Asked by ftfballer24 - Thu Oct 2 19:04:02 2008 - - 1 Answers - 0 Comments

A. The easiest way is to create a command button, with a macro attached, to activate the sheet that contains what you want to view. Then on the sheet with the object being viewed, create a command button, with a macro, to view the sheet you wish to return to. To create the macro to go from Sheet1 to Sheet2: Go to Tools > Macro > Record New Macro. When the New Macro window opens, enter a name that identifies the sheet you are activating, i.e. To_Sheet2. (No spaces are allowed in the name) Then, click on the tab for Sheet 2. Sheet 2 will activate. Go to Tools > Macro > Stop Recording. Next, go to View > Toolbars and select the 'Forms' toolbar. Select the Button icon, 2nd column 2nd one down. Click and drag a button onto… [cont.]
Answered by garbo7441 - Thu Oct 2 20:29:52 2008

What is a good beginner camera for macro photography?
Q. I have become more interested in photography lately and I really enjoy doing macro, the camera i currently own is no good for this and i need something better. i took a class where we used Nikon digital cameras and they seemed nice, is Nikon a good route?
Asked by wikid witch of the west - Tue Jun 24 20:12:17 2008 - - 5 Answers - 0 Comments

A. It is not the camera but the lens that will allow you to shoot macro shots. Nikon makes four macro lenses. AF 60 mm f/2.8, AF-S 60 mm f/2.8, AF-S 105 mm f/2.8 VR and AF 200 mm f/4.0 There are many more used Nikon macro lenses available including the 55 mm f/3.5, 55 mm f/2.8 and more.
Answered by fhotoace - Tue Jun 24 20:16:41 2008

How to make the macro insert pasword Automaticly, when you have program the macro to open any protect file ?
Q. I want to create a macro that open a protected file, but, it need be automatically, without the user need to know that.
Asked by guiga - Tue Aug 12 17:18:40 2008 - - 1 Answers - 0 Comments

A. Here is a macro that will unprotect a password protected sheet, allow you to perform a task or tasks, then automatically password protect the sheet again. Change 'password' to the password for your sheet. Open workbook Copy this macro to clipboard Sub Access_Protected_Sheet() ActiveSheet.Unprotect Password:="password" 'put whatever you want to do here ActiveSheet.Protect DrawingObjects:=True, _ Contents:=True, Scenarios:=True, Password:="password" End Sub Press ALT + F11 Insert > Module Paste the macro to the Module area to the right. Close back to Excel Go to Tools > Macro > Macros Highlight the macro, if it is not already highlighted. Click: Options Select a letter to be used as a keyboard shortcut. Close… [cont.]
Answered by garbo7441 - Tue Aug 12 18:39:17 2008

What do I set my camera to, to take better macro shots?
Q. I bought A Kodak Easyshare Z1012 IS just over a month ago and I am still trying to figure out the macro setting on it. My old camera takes good macro photos with its macro setting, despite it being a fairly older product of Kodak's. Basically I'm asking those out there that might know what focal point, or any other in-camera setting to put it on so it takes focused macro shots. Every time I set it to the macro setting, it still takes blurred photos.
Asked by Snap - Sun Feb 15 11:56:40 2009 - - 1 Answers - 0 Comments

A. You should consult the manual. Look for the min. focus distance (it is 1cm on my pentax P&S) . Try the macro focus mode, if that doesn't work go manual focus.
Answered by YoDaddy . - Sun Feb 15 12:31:47 2009

What is the best digital camera for taking macro shots, and with a great optical zoom for sports shots?
Q. I am trying to get the best camera for my money, and would like to get as much feedback from current camera owners as possible. I love taking up close detailed macro shots of flowers, but I also need something that will do well with my son's sporting events. I am welcome to all suggestions. Thanks!
Asked by Rhonda K - Tue Mar 25 23:20:58 2008 - - 1 Answers - 0 Comments

A. From your requirements, I would say a dSLR camera would be your best option. Either an (entry-level) Canon or Nikon are the two brands I would recommend. They have much better performance than any point & shoot camera, and you can select from a large range of lenses (wide angle, macro tele etc) to suit your needs (and budget). Buying one of these cameras with the kit lens is a good way to start. If a dSLR camera sounds way out of your league, then you can always start shooting in AUTO first, until your knowledge and confidence grows...
Answered by Petra_au - Tue Mar 25 23:42:21 2008

What is global-macro discretionary trading and what are some strategies associated with it?
Q. What is global-macro discretionary trading and what are some strategies associated with it?
Asked by qtlqqknsweethart - Thu Jan 3 10:36:21 2008 - - 1 Answers - 0 Comments

A. Just earlier today I was discussing global macro trading with an associate. He suggested the following book about how hedge funds have been profiting on Global Macro trends: Inside the house of money - by Steven Drobny Here's a blurb on the book: Happy trading!
Answered by JP - Sun Jan 6 01:47:10 2008

What id the diffrence between the 50mm and 100m macro lens?
Q. I am getting a macro lens for my Sony Alpha A200, and deciding between the 50mm and 100mm. What can I take with both of these?
Asked by unknown - Tue Jul 8 20:14:33 2008 - - 3 Answers - 0 Comments

A. The 100mm gives you a better working distance which is handy when photographing bees. Check on eBay for a Minolta Maxxum AF 100mm macro lens and you'll be good to go. The Minolta Maxxum AF1200 macro ring flash is compatible with your Sony A200 except for TTL metering. The 1200 has 4 individual flash tubes which can be switched On or Off so you can use 1, 2, 3 or all 4 tubes. There may be an adapter to allow TTL metering but you'll need to check the Sony website.
Answered by unknown - Wed Jul 9 07:16:09 2008

what do u know about the MACRO feature on a digital camera?
Q. what am i looking for when im choosing a camera that i wanna take macro pictures with? anything i need to look for in particular? (do megapixels have anything to do with the macro feature?) gracias! i cant afford a SLR or those expensive cameras. :( macro focus range: what is the diff between 5cm and 15cm?
Asked by ~dulceria~ - Tue May 13 21:44:39 2008 - - 3 Answers - 0 Comments

A. The number of pixels on a sensor has nothing to do with the macro capability of any camera. We will have to assume you are talking about a P&S camera. Unfortunately, not of the specs on these cameras tell you what the macro capability of the camera really is ... it does tell you how close your can get your camera to the subject, the the actual subject to image size ratio is not indicated. DSLR cameras using macro lenses can be used at 1:2 and on some of the better lenses actual 1:1 magnification ratios. On pixel counts:
Answered by fhotoace - Tue May 13 21:51:13 2008

How do I stop recording a macro in Quattro Pro?
Q. I am using the auto feature and have placed the cursor in the last cell of my report to begin recording the macro. How do I stop recording the macro? I am using the auto feature and have placed the cursor in the last cell of my report to begin recording the macro. How do I stop recording the macro? (The help program is not loaded on my computer)
Asked by Alice F - Mon Jan 19 22:21:02 2009 - - 2 Answers - 0 Comments

A. Go to Tools select Stop Recording
Answered by Astray A - Mon Jan 19 22:30:45 2009

What's the best set-up to capture a macro shot of waterdrops?
Q. I have a budget of only about $50 :/ And I already have a macro lens Any tips? Hints? I've heard people using a glass pan filled with colored water or something like that, and then somehow having something that drops waterdrops at a constant rate.
Asked by Stephen V - Sat Dec 13 17:41:20 2008 - - 2 Answers - 0 Comments

A. My friend uses an IV drip with glycerin
Answered by Perki88 - Sat Dec 13 22:15:35 2008

What type of macro molecule has a sugar-phosphate backbone and what type of monomer does it use?
Q. Name all the bonds used to form a strand of this macro molecule.
Asked by UnruliiScorpio - Tue Sep 30 00:07:34 2008 - - 1 Answers - 0 Comments

A. Nucleic acid. Monomer: nuceotide. Depending on the type of nucleic acid: phosphodiester bonds, H bonds
Answered by fendergrl97 - Tue Sep 30 01:43:28 2008

How do I get an Excel Macro to return a string to another macro?
Q. I'm an Excel VBA beginner. I'm writing a macro (call it A) that calls another macro (B). When B is finished, I want it to return a string to macro A. How would I go about doing that?
Asked by Adam R - Tue Aug 26 12:33:56 2008 - - 1 Answers - 1 Comments

A. By making B a function in this form: Function Bmacro(InputParm1 As Long, InputParm2 As String) As String ... ... Bmacro = "The string you want to return or the name of a variable containing the string" End Function The value Bmacro (the function name - different for every function) must be set somewhere in the macro or it will return a zero length string (for a String data type). Good coding practice is to always set the value in the last statement for the macro. You can have as many or few input parameters as you need. If the As datatype is missing the function will return a variant. Is is always wise to specify the data type (Integer, Long Date, Variant, etc.) even if you want to return a variant. The code in A would look like … [cont.]
Answered by Gary E - Tue Aug 26 17:22:04 2008

How do creationists distinguish between macro evolution and micro evolution?
Q. Do they use a special formula? (Macro^2) X (bible+jesus+2000) X (hypocrasy+lunacy) = i know all Can anyone think of a better formula or give me the actual formula?
Asked by RETURN OF THE FIST (EX L-5 T/C) - Wed Jan 14 08:09:33 2009 - - 17 Answers - 0 Comments

A. Microevolution - any evolution for which evidence is so obvious obfuscation and misrepresentation will not work Macroevolution - any evolution for which slightly more than a basic understanding of biology and evolution is required, such that obfuscation and misrepresentation may be used to "disprove" it.
Answered by aaronmsl - Wed Jan 14 08:14:52 2009

How is evolution ( micro or macro ) more sufficiently proven in todays world to be true as oppose to religion?
Q. How is evolution ( micro or macro ) more sufficiently proven in todays world to be true as oppose to religion and creationism ?
Asked by Labyrinthine_Anghellica - Wed Sep 23 01:30:57 2009 - - 16 Answers - 0 Comments

A. There isnt a distinction between Micro and Macro and MOST scientists will never use the terms, because they use the same mechanism. Its like saying I can walk 10 feet but its impossible to walk a mile, and if for some reason I do get to a mile its because god put me there. The mechanism that requires you to walk 10 feet is the same mechanism that requires you to go 1 mile. If evolution was not true than the majority of modern medical research would not exist as well as several fields of biology.
Answered by homestarr2 - Wed Sep 23 01:41:57 2009

How do I create a macro to perform editing tasks in Excel?
Q. I have a document that I need to delete the SAME rows, delete the same columns, copy the date from one location to another, and then auto-fill...Certainly a macro can help me with this right? I'm self taught in Excel, but very proficient. Point me in the right direction, anyone?
Asked by sciencegod7@att.net - Thu Mar 19 22:54:11 2009 - - 1 Answers - 0 Comments

A. The first step is to record a macro where you do everything you want to do Tools->Macro->Record new macro Then with a fresh sheet re-run the macro and see if it does what you expected it to do If not then go to the macro editor and see if you can work out what to change too make the macro work repeatedly.
Answered by cherria - Thu Mar 19 23:01:20 2009

How can I create a Macro in Excel to change some characters in a cell containing text?
Q. I have a table of 50 rows and 5 columns. In each cell is a string (text) of 8 characters long.I want to delete the last 3 characters and write whatever I want to. I tried this way: Pres F2 key, backspace 3 times, write the new characters, press F2 key and move the cursor right. It doesn't work. The F2 key, backspace and move the cursor are not recorded in the Macro (VBA). How should I do it?
Asked by Puiutu - Thu Aug 30 11:10:41 2007 - - 3 Answers - 0 Comments

A. If you're not tied to a VB answer, it may be easier to do something like this: If your data is on Sheet1 with data beginning in A1 and Sheet2 is blank, go to cell A1 on Sheet 2 and enter =LEFT(Sheet1!A1,5)&"YOURT EXT" Then fill your formula down and right until it's showing all of your data. If you want it as live data and not formulas, Copy/Paste Special>Values. That may be a little simpler overall. Otherwise, the solution above should accomplish the same thing, but I think you'd need to change the second line from s = Left(Target.Text, 8) to s = Left(Target.Text, 5)
Answered by Marty B - Thu Aug 30 11:48:03 2007

How do I get rid of a Mobsters macro that I downloaded onto my computer?
Q. I added this macro that I found online for depositing my money for Mobsters. But now whenever I try to hover over any of the tools at the top of the screen, it's invisible. I just want to remove the macro. And my computer seems to be slower. Please Help!
Asked by sarahbaby992 - Wed Oct 1 08:58:24 2008 - - 2 Answers - 2 Comments

A. Go to start... Go to Set program access and defaults... Go to Change/Remove programs... Find that program and hit remove. Hope I helped. Good luck!
Answered by ~Willow~ - Wed Oct 1 09:01:37 2008