ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Unable ot Break link for Macro with no source (https://www.excelbanter.com/excel-discussion-misc-queries/1637-unable-ot-break-link-macro-no-source.html)

nate_l

Unable ot Break link for Macro with no source
 
I have a spreadheet I want to use going forward, but there are three macros
set to run upon opening. I have tried to break the links and delete the
macros but cannot as they are from an unidentified source. Does anyone know
how to remove these so I no longer get a prompt upon opening my spreadsheet?
--
Regards,
Nate

Dave Peterson

I'm not sure if I understand completely, but if you want to get rid of all the
macros, you can follow the instructions at Debra Dalgleish's site:
http://www.contextures.com/xlfaqMac.html#NoMacros

But this could get rid of macros that you need--so be careful. You may want to
just remove the ones causing trouble???

If you really meant you have links that you don't want, you could use Bill
Manville's FindLink program:
http://www.oaltd.co.uk/MVP/Default.htm



nate_l wrote:

I have a spreadheet I want to use going forward, but there are three macros
set to run upon opening. I have tried to break the links and delete the
macros but cannot as they are from an unidentified source. Does anyone know
how to remove these so I no longer get a prompt upon opening my spreadsheet?
--
Regards,
Nate


--

Dave Peterson


All times are GMT +1. The time now is 02:51 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com