Comentários: valor do Registro fnoteoffv5_35_1 e mais 1UsuárioHKCU\software\policies\microsoft\office\16.0\excel\options\binaryoptions

ID da política: L_Comments
Escopo: Configuração do Usuário
Compatível com: Windows Server 2008 R2 ou Windows 7
Fonte: Microsoft 365 Apps / Office Administrative Templates (versão 5568.1000)
Categoria: Microsoft Excel 2016 › Opções do Excel › Avançado

Registro

fnoteoffv5_35_1

Excluir valorUsuário

HKCU\software\policies\microsoft\office\16.0\excel\options\binaryoptions Chave atual

Valor desabilitado: (excluir valor)

Aplicar com .reg · CMD · PowerShell

Desabilitada

Windows Registry Editor Version 5.00

[HKEY_CURRENT_USER\software\policies\microsoft\office\16.0\excel\options\binaryoptions]
"fnoteoffv5_35_1"=-

CMD · Desabilitada

reg delete "HKCU\software\policies\microsoft\office\16.0\excel\options\binaryoptions" /v "fnoteoffv5_35_1" /f

PowerShell · Desabilitada

Remove-ItemProperty -Path 'HKCU:\software\policies\microsoft\office\16.0\excel\options\binaryoptions' -Name 'fnoteoffv5_35_1'

vmdnotedisp_38_2

REG_DWORDUsuário

HKCU\software\policies\microsoft\office\16.0\excel\options\binaryoptions Chave atual

Valor habilitado: Depende do valor da opção
Elemento: Comentários

Opções
Item	Valor armazenado
Nenhum	0 software\policies\microsoft\office\16.0\excel\options\binaryoptions\fnoteoffv5_35_1 = 1
Somente indicador de comentário	1 software\policies\microsoft\office\16.0\excel\options\binaryoptions\fnoteoffv5_35_1 = 0
Comentários e indicador	2 software\policies\microsoft\office\16.0\excel\options\binaryoptions\fnoteoffv5_35_1 = 0

Aplicar com .reg · CMD · PowerShell

.reg

Windows Registry Editor Version 5.00

[HKEY_CURRENT_USER\software\policies\microsoft\office\16.0\excel\options\binaryoptions]

; Opções (use apenas uma)
; Nenhum
"vmdnotedisp_38_2"=dword:00000000
"fnoteoffv5_35_1"=dword:00000001
; Somente indicador de comentário
"vmdnotedisp_38_2"=dword:00000001
"fnoteoffv5_35_1"=dword:00000000
; Comentários e indicador
"vmdnotedisp_38_2"=dword:00000002
"fnoteoffv5_35_1"=dword:00000000

CMD

:: Opções (use apenas uma)

:: Nenhum
reg add "HKCU\software\policies\microsoft\office\16.0\excel\options\binaryoptions" /v "vmdnotedisp_38_2" /t REG_DWORD /d 0 /f
reg add "HKCU\software\policies\microsoft\office\16.0\excel\options\binaryoptions" /v "fnoteoffv5_35_1" /t REG_DWORD /d 1 /f
:: Somente indicador de comentário
reg add "HKCU\software\policies\microsoft\office\16.0\excel\options\binaryoptions" /v "vmdnotedisp_38_2" /t REG_DWORD /d 1 /f
reg add "HKCU\software\policies\microsoft\office\16.0\excel\options\binaryoptions" /v "fnoteoffv5_35_1" /t REG_DWORD /d 0 /f
:: Comentários e indicador
reg add "HKCU\software\policies\microsoft\office\16.0\excel\options\binaryoptions" /v "vmdnotedisp_38_2" /t REG_DWORD /d 2 /f
reg add "HKCU\software\policies\microsoft\office\16.0\excel\options\binaryoptions" /v "fnoteoffv5_35_1" /t REG_DWORD /d 0 /f

PowerShell

# Comum: criar a chave
New-Item -Path 'HKCU:\software\policies\microsoft\office\16.0\excel\options\binaryoptions' -Force | Out-Null

# Opções (use apenas uma)
# Nenhum
New-ItemProperty -Path 'HKCU:\software\policies\microsoft\office\16.0\excel\options\binaryoptions' -Name 'vmdnotedisp_38_2' -PropertyType DWord -Value 0 -Force | Out-Null
New-ItemProperty -Path 'HKCU:\software\policies\microsoft\office\16.0\excel\options\binaryoptions' -Name 'fnoteoffv5_35_1' -PropertyType DWord -Value 1 -Force | Out-Null
# Somente indicador de comentário
New-ItemProperty -Path 'HKCU:\software\policies\microsoft\office\16.0\excel\options\binaryoptions' -Name 'vmdnotedisp_38_2' -PropertyType DWord -Value 1 -Force | Out-Null
New-ItemProperty -Path 'HKCU:\software\policies\microsoft\office\16.0\excel\options\binaryoptions' -Name 'fnoteoffv5_35_1' -PropertyType DWord -Value 0 -Force | Out-Null
# Comentários e indicador
New-ItemProperty -Path 'HKCU:\software\policies\microsoft\office\16.0\excel\options\binaryoptions' -Name 'vmdnotedisp_38_2' -PropertyType DWord -Value 2 -Force | Out-Null
New-ItemProperty -Path 'HKCU:\software\policies\microsoft\office\16.0\excel\options\binaryoptions' -Name 'fnoteoffv5_35_1' -PropertyType DWord -Value 0 -Force | Out-Null