If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Can't open XLS file I created
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 ! |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
Can't open XLS file I created
Following Pecoflyer's message, here is how to change macro security
1.. On the Tools menu, click Options. 2.. Click the Security tab. 3.. Under Macro Security, click Macro Security. 4.. Click the Security Level tab, and then select the security level you want to use. best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Bubey" wrote in message ... 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 ! |
#4
|
|||
|
|||
Can't open XLS file I created
Thank you for the info, it worked perfectly. My Excel version is Ofc 2000.
"Pecoflyer" wrote in message ... 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 |
#5
|
|||
|
|||
Can't open XLS file I created
Thanks for the info !
"Bernard Liengme" wrote in message ... Following Pecoflyer's message, here is how to change macro security 1.. On the Tools menu, click Options. 2.. Click the Security tab. 3.. Under Macro Security, click Macro Security. 4.. Click the Security Level tab, and then select the security level you want to use. best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Bubey" wrote in message ... 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 ! |
Thread Tools | |
Display Modes | |
|
|