Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need to defeat this security warning message
I tried to use vba earlier to enhance a spreadsheet but it didn't work so I
deleted it. Now every time I try to save the worksheet I get the following message: "Privacy Warning: This document contains macros, ActiveX controls, XML expansion pack information, or web components. These may include personal information that cannot be removed by the "Remove personal information from profile properties on save" option in the Security tab of the Options dialog box on the tools menu." I followed the instructions here <http://www.contextures.com/xlfaqMac.html for removing all VBA code, but I still get the privacy warning. Is there anything I can do to rid this spreadsheet of this "impending doom" message? I need to move this workbook into a production environment and people are not going to want to use it if it looks like their private information is going to be compromised. Thanks - Steve |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need to defeat this security warning message
Did you delete any modules that were created? This sometimes causes a
problem. -- -- -John Please rate when your question is answered to help us and others know what is helpful. "stebro" wrote in message ... I tried to use vba earlier to enhance a spreadsheet but it didn't work so I deleted it. Now every time I try to save the worksheet I get the following message: "Privacy Warning: This document contains macros, ActiveX controls, XML expansion pack information, or web components. These may include personal information that cannot be removed by the "Remove personal information from profile properties on save" option in the Security tab of the Options dialog box on the tools menu." I followed the instructions here <http://www.contextures.com/xlfaqMac.html for removing all VBA code, but I still get the privacy warning. Is there anything I can do to rid this spreadsheet of this "impending doom" message? I need to move this workbook into a production environment and people are not going to want to use it if it looks like their private information is going to be compromised. Thanks - Steve |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need to defeat this security warning message
Thanks John for responding - this is a tough one. I did everything in the link below offered as the proper way to remove vba code from the workbook... <http://www.contextures.com/xlfaqMac.html This site basically tells you how to go in and delete anything - even spaces that makes it look like there is code in there - and in a couple of cases modules to delete, but I don't think in my case I had to delete anything. Also, I tried changing the macro security settings but that didn't work either, and even if it did it still leaves the problem for someone else to "discover" and it would look like I was passing something fishy off on them... --Steve "John Bundy" wrote: Did you delete any modules that were created? This sometimes causes a problem. -- -- -John Please rate when your question is answered to help us and others know what is helpful. "stebro" wrote in message ... I tried to use vba earlier to enhance a spreadsheet but it didn't work so I deleted it. Now every time I try to save the worksheet I get the following message: "Privacy Warning: This document contains macros, ActiveX controls, XML expansion pack information, or web components. These may include personal information that cannot be removed by the "Remove personal information from profile properties on save" option in the Security tab of the Options dialog box on the tools menu." I followed the instructions here <http://www.contextures.com/xlfaqMac.html for removing all VBA code, but I still get the privacy warning. Is there anything I can do to rid this spreadsheet of this "impending doom" message? I need to move this workbook into a production environment and people are not going to want to use it if it looks like their private information is going to be compromised. Thanks - Steve |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need to defeat this security warning message
Is there anyway you can just copy all of those sheets to a different
workbook? I've never had to but it should not come up after that, just select all sheets, right click, Move or copy, select a new workbook and check the create copy box. Sorry if you already knew that. Let me know if that fixes it. -- -- -John Please rate when your question is answered to help us and others know what is helpful. "stebro" wrote in message ... Thanks John for responding - this is a tough one. I did everything in the link below offered as the proper way to remove vba code from the workbook... <http://www.contextures.com/xlfaqMac.html This site basically tells you how to go in and delete anything - even spaces that makes it look like there is code in there - and in a couple of cases modules to delete, but I don't think in my case I had to delete anything. Also, I tried changing the macro security settings but that didn't work either, and even if it did it still leaves the problem for someone else to "discover" and it would look like I was passing something fishy off on them... --Steve "John Bundy" wrote: Did you delete any modules that were created? This sometimes causes a problem. -- -- -John Please rate when your question is answered to help us and others know what is helpful. "stebro" wrote in message ... I tried to use vba earlier to enhance a spreadsheet but it didn't work so I deleted it. Now every time I try to save the worksheet I get the following message: "Privacy Warning: This document contains macros, ActiveX controls, XML expansion pack information, or web components. These may include personal information that cannot be removed by the "Remove personal information from profile properties on save" option in the Security tab of the Options dialog box on the tools menu." I followed the instructions here <http://www.contextures.com/xlfaqMac.html for removing all VBA code, but I still get the privacy warning. Is there anything I can do to rid this spreadsheet of this "impending doom" message? I need to move this workbook into a production environment and people are not going to want to use it if it looks like their private information is going to be compromised. Thanks - Steve |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need to defeat this security warning message
Choose ToolsOptions
On the Security tab, remove the check mark from 'Remove personal information from file properties on save' Click OK stebro wrote: I tried to use vba earlier to enhance a spreadsheet but it didn't work so I deleted it. Now every time I try to save the worksheet I get the following message: "Privacy Warning: This document contains macros, ActiveX controls, XML expansion pack information, or web components. These may include personal information that cannot be removed by the "Remove personal information from profile properties on save" option in the Security tab of the Options dialog box on the tools menu." I followed the instructions here <http://www.contextures.com/xlfaqMac.html for removing all VBA code, but I still get the privacy warning. Is there anything I can do to rid this spreadsheet of this "impending doom" message? I need to move this workbook into a production environment and people are not going to want to use it if it looks like their private information is going to be compromised. Thanks - Steve -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need to defeat this security warning message
Cool - I get to speak with the author herself! Thanks Debra - this caused the error message to quit, but have I only masked a problem? If the person who uses this has this check box turned on with they too get this warning? My attempts were geared towards removing the root cause, but perhaps the message here is that it is not possible. To me this is too wierd. Thanks so much for your assistance! Steve "Debra Dalgleish" wrote: Choose ToolsOptions On the Security tab, remove the check mark from 'Remove personal information from file properties on save' Click OK stebro wrote: I tried to use vba earlier to enhance a spreadsheet but it didn't work so I deleted it. Now every time I try to save the worksheet I get the following message: "Privacy Warning: This document contains macros, ActiveX controls, XML expansion pack information, or web components. These may include personal information that cannot be removed by the "Remove personal information from profile properties on save" option in the Security tab of the Options dialog box on the tools menu." I followed the instructions here <http://www.contextures.com/xlfaqMac.html for removing all VBA code, but I still get the privacy warning. Is there anything I can do to rid this spreadsheet of this "impending doom" message? I need to move this workbook into a production environment and people are not going to want to use it if it looks like their private information is going to be compromised. Thanks - Steve -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need to defeat this security warning message
Hi Steve,
The Privacy message is created by a workbook setting, so shouldn't be affected by settings on the users' machines. It's different than the Security warning that's displayed based on a user's security setting. The Privacy message seems to be triggered even if you open the Visual Basic Explorer, without creating a macro. Once the message has been triggered, I don't know of any way to remove it from the workbook, aside from turning off that 'Remove personal information' option. Debra stebro wrote: Cool - I get to speak with the author herself! Thanks Debra - this caused the error message to quit, but have I only masked a problem? If the person who uses this has this check box turned on with they too get this warning? My attempts were geared towards removing the root cause, but perhaps the message here is that it is not possible. To me this is too wierd. Thanks so much for your assistance! Steve "Debra Dalgleish" wrote: Choose ToolsOptions On the Security tab, remove the check mark from 'Remove personal information from file properties on save' Click OK stebro wrote: I tried to use vba earlier to enhance a spreadsheet but it didn't work so I deleted it. Now every time I try to save the worksheet I get the following message: "Privacy Warning: This document contains macros, ActiveX controls, XML expansion pack information, or web components. These may include personal information that cannot be removed by the "Remove personal information from profile properties on save" option in the Security tab of the Options dialog box on the tools menu." I followed the instructions here <http://www.contextures.com/xlfaqMac.html for removing all VBA code, but I still get the privacy warning. Is there anything I can do to rid this spreadsheet of this "impending doom" message? I need to move this workbook into a production environment and people are not going to want to use it if it looks like their private information is going to be compromised. Thanks - Steve -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need to defeat this security warning message
Thanks Debra - and to all who responded or who help others in this forum. I'm going to mark this as "problem resolved", but if anyone else has anything to add please do. It still is a little puzzling to me but I've learned that some things you just have to take on faith! As long as the users of this workbook don't think I'm passing off a virus-infected, personal info stealing robot - I'm o.k. with it. --Steve "Debra Dalgleish" wrote: Hi Steve, The Privacy message is created by a workbook setting, so shouldn't be affected by settings on the users' machines. It's different than the Security warning that's displayed based on a user's security setting. The Privacy message seems to be triggered even if you open the Visual Basic Explorer, without creating a macro. Once the message has been triggered, I don't know of any way to remove it from the workbook, aside from turning off that 'Remove personal information' option. Debra stebro wrote: Cool - I get to speak with the author herself! Thanks Debra - this caused the error message to quit, but have I only masked a problem? If the person who uses this has this check box turned on with they too get this warning? My attempts were geared towards removing the root cause, but perhaps the message here is that it is not possible. To me this is too wierd. Thanks so much for your assistance! Steve "Debra Dalgleish" wrote: Choose ToolsOptions On the Security tab, remove the check mark from 'Remove personal information from file properties on save' Click OK stebro wrote: I tried to use vba earlier to enhance a spreadsheet but it didn't work so I deleted it. Now every time I try to save the worksheet I get the following message: "Privacy Warning: This document contains macros, ActiveX controls, XML expansion pack information, or web components. These may include personal information that cannot be removed by the "Remove personal information from profile properties on save" option in the Security tab of the Options dialog box on the tools menu." I followed the instructions here <http://www.contextures.com/xlfaqMac.html for removing all VBA code, but I still get the privacy warning. Is there anything I can do to rid this spreadsheet of this "impending doom" message? I need to move this workbook into a production environment and people are not going to want to use it if it looks like their private information is going to be compromised. Thanks - Steve -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need to defeat this security warning message
Unless it's company policy that you leave that Privacy setting turned
on, I'd turn it off. Then users won't see any alarming messages, and won't be worried about your workbook. There's a bit more information in the following MSKB articles: OFFXP: "Remove Personal Information from This File on Save" May Not Work with Macros http://support.microsoft.com/kb/286394 How to minimize metadata in Microsoft Excel workbooks http://support.microsoft.com/kb/223789 stebro wrote: Thanks Debra - and to all who responded or who help others in this forum. I'm going to mark this as "problem resolved", but if anyone else has anything to add please do. It still is a little puzzling to me but I've learned that some things you just have to take on faith! As long as the users of this workbook don't think I'm passing off a virus-infected, personal info stealing robot - I'm o.k. with it. --Steve "Debra Dalgleish" wrote: Hi Steve, The Privacy message is created by a workbook setting, so shouldn't be affected by settings on the users' machines. It's different than the Security warning that's displayed based on a user's security setting. The Privacy message seems to be triggered even if you open the Visual Basic Explorer, without creating a macro. Once the message has been triggered, I don't know of any way to remove it from the workbook, aside from turning off that 'Remove personal information' option. Debra stebro wrote: Cool - I get to speak with the author herself! Thanks Debra - this caused the error message to quit, but have I only masked a problem? If the person who uses this has this check box turned on with they too get this warning? My attempts were geared towards removing the root cause, but perhaps the message here is that it is not possible. To me this is too wierd. Thanks so much for your assistance! Steve "Debra Dalgleish" wrote: Choose ToolsOptions On the Security tab, remove the check mark from 'Remove personal information from file properties on save' Click OK stebro wrote: I tried to use vba earlier to enhance a spreadsheet but it didn't work so I deleted it. Now every time I try to save the worksheet I get the following message: "Privacy Warning: This document contains macros, ActiveX controls, XML expansion pack information, or web components. These may include personal information that cannot be removed by the "Remove personal information from profile properties on save" option in the Security tab of the Options dialog box on the tools menu." I followed the instructions here <http://www.contextures.com/xlfaqMac.html for removing all VBA code, but I still get the privacy warning. Is there anything I can do to rid this spreadsheet of this "impending doom" message? I need to move this workbook into a production environment and people are not going to want to use it if it looks like their private information is going to be compromised. Thanks - Steve -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Warning Message | Excel Discussion (Misc queries) | |||
Turning of merge warning message | Excel Discussion (Misc queries) | |||
How to disable Security Warning for Excel 2003 with NO macros | Setting up and Configuration of Excel | |||
warning or message before saving spreadsheet | Excel Worksheet Functions |