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
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
blah blah blah then run the macro to check/un-check/enable the above points.
Thanks in advance
galvinpaddy!
Bookmarks