Bubey;246826 Wrote:
Window XP Sp2 - MS Ofc 2000 / Excel
I created a list in Excel by doing a copy/past from a web site.
(List of name, address, phone, website) I did a save when done
and then tried to disable all the hyperlinks on the page. Followed
directions I got off the web, F11/Macro to remove hyperlinks.
I closed and saved and then when I tried to re-open it but got
the following error msg:
'The workbook contains a type of Macro (MS Excel ver. 4 macro)
that cannot be disabled nor signed. Therefore, this workbook
cannot be opened under High Security Level.'
This is all Greek to me, please help so I can get it opened,
removed the hyperlinks and make like a plain Excel file again.
Thanks in advance for your help !
Maybe first scan the file for viruses.
Then go to Tools - Macro - Security and set the Security Level to
"Low"
Open your file and remove unwanted macros
Reset the security level to High
HTH
--
Pecoflyer
Cheers -
*'Membership is free' (
http://www.thecodecage.com)* & allows file
upload -faster and better answers
*Adding your XL version* to your post helps finding solution faster
------------------------------------------------------------------------
Pecoflyer's Profile:
http://www.thecodecage.com/forumz/member.php?userid=14
View this thread:
http://www.thecodecage.com/forumz/sh...ad.php?t=68882