Please help me to adapt this macro to define WrapFormat to all images in a document

Office

Question:I found a macro posted to Microsoft by Jay Freedman responses on 13 January 2012 - converts an InlineShape shaped and then sets the WrapBehind WrapFormat. This macro code is as follows:X() {sub}Dim SLI as InlineShapeDim shp as shapeSet ActiveDocument.InlineShapes = SLI (1)Set shp = SLI.ConvertToShape methodWith shp.WrapFormat.Type = wdWrapBehind.RelativeVerticalPosition = wdRelativeVerticalPositionMargin...Read More

Posted: 10 May 2012

Tags: Please help me to adapt this macro to define WrapFormat to all images in a document Please help adapt this macro define WrapFormat all images document

Macro to resize an image in Word

Office

Question:I recorded a macro where I want, what I choose to resize.The macro works very well on any form, but I want it to resize a chart I infer Excel to word as a gif. When I click on the graphic image in Word 2007 and run the macro it does resize. If I right click on the chart he described as an image. Appreciated assistance.The code I have is...Sub Resize()"Resize Macro."''Selection.ShapeRange....Read More

Posted: 18 Apr 2012

Tags: Macro to resize an image in Word Macro resize image Word

Insert a check box in a Macro

Office

Question:Hello. I am working on a Macro to insert a bunch of things in another workbook and insert a check box to control information. The workbook with which I work is attached.I have everything works correctly except for the function of the check box. Problems:1. The box fits in a different place that I asked.2. Check boxes on the right of the new need to be updated to reflect a new target, which...Read More

Posted: 15 Apr 2012

Tags: Insert a check box in a Macro Insert check box Macro

Problem caused by the update: error message "the macro cannot be found or has been disabled because of your macro security settings".

Office

Question:Since accepting that the Windows of the most recent update two days ago, I get an error message whenever I start Word, read:"The macro cannot be found or has been disabled because of your macro security settings"It takes two or three clicks OK to get rid. Another message back when close a Word document.The same thing is happening on the computer of my wife because it has installed the latest...Read More

Posted: 14 Apr 2012

Tags: Problem caused by the update error message the macro cannot be found or has been disabled because of your macro security settings Problem caused the update error message macro cannot found has been disabled because your security settings

Exit a loop Macro Excel

Office

Question:The macro below works very well as expected.Sub UpToNumber()'' UpToNumber MacroDim rCell As RangeSet rCell = (1, 1) selectionDo While rCell.Row > 1Set rCell = rCell.Offset-1 (0)If IsNumeric (rCell.Value) and then quitLooprCell.Select'End SubNow how can I change the condition if IsNumericIf the value = the value of L1 and output of cell...I use Excel for mac 2011 on an iMac OSXAnswer:TryIf...Read More

Posted: 06 Apr 2012

Tags: Exit a loop Macro Excel Exit loop Macro Excel