Unlock the Macro file every time using the file property

[sksanjeev786]

Hi Team,

Do we have any other option? to unlock at once instead of unlocking every Macro file we are getting from different system.

 

[KOKOSEK]

I am afraid not (I am not sure). BUT...
You can use tiny powershell script like below:

#[String]$curDir = Split-Path $MyInvocation.MyCommand.Path -Parent
#[String]$curDir = $ENV:TEMP
[String]$curDir =  "\MyMagicFolderWhereIHaveDownloaded XLFiles to unlock"
Get-Childitem -Path ($curDir + "\*.xls*") -Recurse -File | % { $_.IsReadOnly=$false }
Get-ChildItem -Path $curDir -Recurse | Where-Object{ $_.Extension -in '.xlsm', '.xls'} | Unblock-File

put this into MyUnlocker.ps1 file and everytime when you got any new file and know that have to be unlock run this file.

 

[sksanjeev786]

I am afraid not (I am not sure). BUT...
You can use tiny powershell script like below:

#[String]$curDir = Split-Path $MyInvocation.MyCommand.Path -Parent
#[String]$curDir = $ENV:TEMP
[String]$curDir =  "\MyMagicFolderWhereIHaveDownloaded XLFiles to unlock"
Get-Childitem -Path ($curDir + "\*.xls*") -Recurse -File | % { $_.IsReadOnly=$false }
Get-ChildItem -Path $curDir -Recurse | Where-Object{ $_.Extension -in '.xlsm', '.xls'} | Unblock-File

put this into MyUnlocker.ps1 file and everytime when you got any new file and know that have to be unlock run this file.

sure! I will try this and let you know if we have any questions.

Wanted to check do we have any other option apart from the above things like going to File Menu>Option>Trust Center>>Any option?
Thank you