Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Office > Excel

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 06-14-2009, 06:02 AM
freebee2 freebee2 is offline Windows Vista Office 2007 (Version 12.0)
Novice
 
Join Date: Oct 2008
Posts: 5
freebee2 is on a distinguished road
Default Privacy warning.

I have a Excel 2007database that has in input Page that if I enter a Serial No. it will give me the information required; dates, type, model etc. Every time I close it down or save, I have to have to complete the message below, is there some way to stop this coming up on screen.

! Privacy warning: This document contains macros; Active X controls, XML expansion pack information, or Web components. These may include personnel information that cannot be removed by document inspector. With the option of Ok - Cancel

Thanks, Freebee2.
Reply With Quote
  #2  
Old 06-23-2009, 10:47 PM
zyzzyva57 zyzzyva57 is offline Windows 7 Office 2007 (Version 12.0)
Expert
 
Join Date: Mar 2009
Location: Dawsonville, Ga (NE of Atl)
Posts: 293
zyzzyva57 is on a distinguished road
Default

On the Developer tab, in the Code group, click Macro Security.

  1. Tip If the Developer tab is not displayed, click the Microsoft Office Button , click Excel Options, and then in the Popular category, under Top options for working with Excel, click Show Developer tab in the Ribbon.
  2. In the Macro Settings category, under Macro Settings, click the option that you want. Note Any changes that you make in the Macro Settings category in Excel apply only to Excel and do not affect any other Microsoft Office program.
Citation and more...
Reply With Quote
  #3  
Old 06-24-2009, 12:06 PM
freebee2 freebee2 is offline Windows Vista Office 2007 (Version 12.0)
Novice
 
Join Date: Oct 2008
Posts: 5
freebee2 is on a distinguished road
Default

Thanks zyzzyva57
I found the answer in the link you gave me, they were working with the same problem I have in the Microsoft Online discussion group.
For any anyone else that has the problem, press Developer; Macro Security; Privacy options; Document-Pacific settings, untic the box for "Remove Personal Information from file properties on Save" and press ok to exit.

Thanks Freebee2
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
File conversion Warning Box On Save ding dong Word 11 04-12-2009 09:46 AM
Internet Security Warning (for Outlook) nolacane Outlook 1 06-21-2006 06:21 PM


All times are GMT -4. The time now is 12:33 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.3.2 ©2009, Crawlability, Inc.