View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Pecoflyer[_197_] Pecoflyer[_197_] is offline
external usenet poster
 
Posts: 1
Default Can't open XLS file I created


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