Please write a EXCEL macros, run macros automatically open the selected range of all hyperlinks.
[Users questions | Browse:45 | Favorites]
Users questions: Please write a EXCEL macros, run macros automatically open all hyperlinks in the selected range, opened the cell where the hyperlink color to red. up
Experts answer: code is as follows: PrivateSubWorksheet_SelectionChange (ByV alTargetAsRange) DimcAsRangeOnErrorResumeNextForEachcInSelectionc.Hyperlinks (1). FollowNewWindow: = True Ifc.Font.Underline = xlUnderlineStyleSingleThen: c.Interior.ColorIndex = 3NextEndSub instructions, open the Excel worksheet, select that area The area is open all the links, so the range of one-time Do not choose too big, or too many pages open, cause the computer is slow. Accessories: xxxx.xls
Experts answer: code is as follows: PrivateSubWorksheet_SelectionChange (ByV alTargetAsRange) DimcAsRangeOnErrorResumeNextForEachcInSelectionc.Hyperlinks (1). FollowNewWindow: = True Ifc.Font.Underline = xlUnderlineStyleSingleThen: c.Interior.ColorIndex = 3NextEndSub instructions, open the Excel worksheet, select that area The area is open all the links, so the range of one-time Do not choose too big, or too many pages open, cause the computer is slow. Accessories: xxxx.xls
- There are several new methods of presentation, simply out of.
- What word in how to increase the special symbols
- excel how to filter and distinguish between the number of consecutive
- How will the characters in the cell and breakdown of figures show?
- How to set excel in the integer "0" format
- How to convert PDF text editable word or TXT
- How could such a problem?
- Help explain, EXCEL function of usage, there are accessories.
- Why not let me see My Network Places?
- EXCEL delivery table and more, how do
- This information provided by the users.Thanks!
Computer Knowledge Copyright 2005-2015 All Rights Reserved.