hyperlinks - macro not working to take them off the sheet
 

I asked a question earlier, and the answer was to make a macro
This explains what you need to do:
http://www.techonthenet.com/excel/macros/delete_hl.php

Basically you have to create a macro to remove all hyperlinks at once. The
link provides detailed instructions on how to do it.

If you get stuck just post another question and someone can walk you through
it.

Answer: You will need to create a macro to delete the hyperlink addresses
in your Excel sheet.
Open your Excel spreadsheet that you wish to remove the hyperlinks from.
Press <ALT-F11 to go to the Visual Basic editor. Create a new module. You
can do this by selecting Module under the Insert menu.
Paste the following code into your new module:
Sub RemoveHyperlinks()
'Remove all hyperlinks from the active sheet
ActiveSheet.Hyperlinks.Delete
End Sub
Close the Visual Basic editor window by selecting "Close and Return to
Microsoft Excel" under the File menu.
Now, go to the sheet that contains the hyperlinks that you wish to delete.
Here is an example of a sheet with multiple hyperlink addresses:


Under the Tools menu, select Macro Macros. Highlight the macro called
"RemoveHyperlinks" and click on the Run button.

Now your hyperlinks should be deleted as you can see by the example below:


If you need to remove hyperlinks from other sheets, just repeat the steps
above.


THIS DOES NOT WORK FOR ME. I GET A SECURITY
i HAVE READ ALL THE SECURITY, and have tried most.
Does anyone have any simple suggestions? just absolutly stressed in TEXAS

hyperlinks - macro not working to take them off the sheet
 

is this a workplace issue?Macros can be dangerous for windows users.If you
cant change security settings you need to speak to your 'system
administrator"If you want to run this macro go to tools/macro/security/and
change to medium.This will alert you that there is a macro installed,and you
have to click OK to allow it to run.If you cant change the security level see
above.
--
paul

remove nospam for email addy!



"Lorelei" wrote:

I asked a question earlier, and the answer was to make a macro
This explains what you need to do:
http://www.techonthenet.com/excel/macros/delete_hl.php

Basically you have to create a macro to remove all hyperlinks at once. The
link provides detailed instructions on how to do it.

If you get stuck just post another question and someone can walk you through
it.

Answer: You will need to create a macro to delete the hyperlink addresses
in your Excel sheet.
Open your Excel spreadsheet that you wish to remove the hyperlinks from.
Press <ALT-F11 to go to the Visual Basic editor. Create a new module. You
can do this by selecting Module under the Insert menu.
Paste the following code into your new module:
Sub RemoveHyperlinks()
'Remove all hyperlinks from the active sheet
ActiveSheet.Hyperlinks.Delete
End Sub
Close the Visual Basic editor window by selecting "Close and Return to
Microsoft Excel" under the File menu.
Now, go to the sheet that contains the hyperlinks that you wish to delete.
Here is an example of a sheet with multiple hyperlink addresses:


Under the Tools menu, select Macro Macros. Highlight the macro called
"RemoveHyperlinks" and click on the Run button.

Now your hyperlinks should be deleted as you can see by the example below:


If you need to remove hyperlinks from other sheets, just repeat the steps
above.


THIS DOES NOT WORK FOR ME. I GET A SECURITY
i HAVE READ ALL THE SECURITY, and have tried most.
Does anyone have any simple suggestions? just absolutly stressed in TEXAS