+ Reply to Thread
Results 1 to 4 of 4

Excel 2010 Trust Center - How to Un-Trust

  1. #1
    Forum Contributor
    Join Date
    10-25-2010
    Location
    Phoenix, Arizona, USA
    MS-Off Ver
    O365
    Posts
    201

    Excel 2010 Trust Center - How to Un-Trust

    I am just starting to use Excel 2010. I have a file that I initially marked as "trusted", which allows opening the file (which has VBA) without being asked to enable Macros each time.

    I want to un-trust this file.

    Can I reverse what I did to trust it? I've gone to the Trust Center, but I can not find anything to distrust the file.

    Thankx for your help.

  2. #2
    Forum Contributor rajeshturaha's Avatar
    Join Date
    08-22-2012
    Location
    Assam, India
    MS-Off Ver
    Excel 2003, 2007
    Posts
    236

    Re: Excel 2010 Trust Center - How to Un-Trust

    Excel option>Trust center>macro setting>Disable all macros without notification & trust access to the VBA project object model
    Rgd
    RT
    If my answer(s) helped you, please add me reputation by click on *

  3. #3
    Forum Contributor
    Join Date
    10-25-2010
    Location
    Phoenix, Arizona, USA
    MS-Off Ver
    O365
    Posts
    201

    Re: Excel 2010 Trust Center - How to Un-Trust

    That will disable ALL workbooks with macros.

    I only want to un-trust this particular workbook.

    Any one else have an idea?

  4. #4
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Excel 2010 Trust Center - How to Un-Trust

    Assuming you did not add a signature to the project (which I reckon you would remember), its probably in a trusted folder (you can find a list in Trust Center).

    Move it to a folder that isn't on that list.
    Entia non sunt multiplicanda sine necessitate

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Trust Center functionality and usage
    By djkirk in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-10-2012, 02:04 PM
  2. [SOLVED] One of the Settings in Options Trust Center Settings is Grayed out
    By zit1343 in forum Excel General
    Replies: 2
    Last Post: 06-28-2012, 09:18 AM
  3. Automating Trusted Location in Trust Center
    By gren in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-14-2011, 02:11 AM
  4. Excel 2007 : Cant get trust center
    By amsanborn in forum Excel General
    Replies: 4
    Last Post: 07-22-2010, 12:39 PM
  5. [SOLVED] How to create a script to trust an assembly - Excel 2003 - Office System Project with C#
    By John Yung in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-06-2005, 10:05 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1