+ Reply to Thread
Results 1 to 1 of 1

VBA to turn on certain excel features

  1. #1
    Forum Contributor
    Join Date
    11-02-2011
    Location
    Rugby, England
    MS-Off Ver
    Office 365
    Posts
    846

    VBA to turn on certain excel features

    morning all,

    in new workplace im using my previous experience of excel to help automate certain reports that we run, however, many pc's within the warehouse have the following things that need to be done before the
    Please Login or Register  to view this content.
    codes (among others) will work:

    Trust Center
    Macro Settings - 'Enable all Macros'
    Protected View - Untick 'Enable protected view for files located in potentially unsafe loctaions' & 'Enable protected view for outlook attachments'
    Privacy Options - Untick 'Remove personal information from file properties on save'

    If we only had 10 pcs then i wouldnt be here - we have almost 100 pc's that the management team log into throughout the day, is there any way to do the above upon excel being opened? I'm inclined to think not but i thought i'd ask before hand.
    Also - dont know if it would be helpful or not, its only specific log in names that will be suing the macros so i would be using something like
    Please Login or Register  to view this content.
    blah blah blah then run the macro to check/un-check/enable the above points.

    Thanks in advance

    galvinpaddy!
    Last edited by galvinpaddy; 02-03-2015 at 09:29 PM. Reason: added detail

+ 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. Excel Features you wish Existed
    By squiggler47 in forum The Water Cooler
    Replies: 14
    Last Post: 07-15-2009, 09:55 AM
  2. Unlocking excel features
    By Jeni R in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-31-2006, 01:53 PM
  3. [SOLVED] what are the new features of excel 2003?
    By ellen in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-05-2006, 05:25 AM
  4. I would like to see a few new features in Excel
    By rkareha in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-08-2006, 12:35 PM
  5. Replies: 1
    Last Post: 07-16-2005, 08: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