Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 05-19-2016, 08:00 AM
Izzie7 Izzie7 is offline Format figure pasted from browser Windows 7 64bit Format figure pasted from browser Office 2010 32bit
Novice
Format figure pasted from browser
 
Join Date: Nov 2014
Location: Israel
Posts: 5
Izzie7 is on a distinguished road
Default Format figure pasted from browser

After pasting a figure from browser, I want to remove the hyperlink and resize the shape. I tried recording the steps but the resize did not recored and what did record was this:
Sub Macro1()


'
' Macro1 Macro
'
'
Selection.PasteAndFormat (wdPasteDefault)
Selection.MoveLeft Unit:=wdCharacter, Count:=1, Extend:=wdExtend
Selection.ShapeRange.Hyperlink.Delete
End Sub

When run, the hyperlink was removed, but then the macro stopped with an error message.
How can this simple task be done with VBA?
I thank you in advance!
Reply With Quote
 

Tags
hyperlinks, resize objects, shapes



Similar Threads
Thread Thread Starter Forum Replies Last Post
Caption Order: Figure 4 Figure 3 Figure 2 golfarchitect13 Word 5 05-07-2014 07:15 PM
Footnotes do not appear when document is pasted into new format JerryL Word 4 12-09-2013 04:33 PM
Format figure pasted from browser Figure and Table Numbering Format Change hojkoff Word 3 06-18-2013 01:57 AM
Format figure pasted from browser auto-format items pasted into document ekphrasis Word 1 11-01-2010 03:02 PM
hyperlinks from copying in web browser are long format... BERKEY Word 0 12-14-2007 10:33 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:23 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft