The information in this article applies to:
SYMPTOMSIn Microsoft Excel 98 Macintosh Edition, if you remove a hyperlink from a cell in a worksheet, borders applied to the cell may also be removed. CAUSEThis problem will occur if you click the Remove Link button in the Edit Hyperlink dialog box or if you use the Delete method in a Visual Basic macro to delete a hyperlink, as in the following example:
WORKAROUNDTo manually remove a hyperlink from a cell without removing the cell's borders, follow these steps:
By setting the Range for the hyperlink to a blank string (""), you can
effectively remove the hyperlink without actually deleting it.
STATUSMicrosoft has confirmed this to be a problem in the versions of Microsoft Excel listed at the beginning of this article. MORE INFORMATION
In Microsoft Excel 98 Macintosh Edition, you can add a hyperlink to a cell
by clicking Hyperlink on the Insert menu. Hyperlinks can link to Web pages,
other workbooks or documents, or other locations within the same workbook.
Additional query words: XL98
Keywords : kbweb xlvbainfo xlformat |
Last Reviewed: January 19, 2000 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |