![Inline image 2](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjbLnyVGZM5QP33vt5grRtZsjgsHzHpab_ArQ2-_na0mjiOxICl_zwzTBOiZXLKe4Sma22EfFiViUmbY_GbHhS8T0oUAdUSPTELhfxzSY7OpgToanM5sdJBK0mBtGxVtuPiKSitrqNpw19C/s1600/VBA_Header_Andre_Luiz_Bernardes_080-743206.jpg)
Às vezes escolhemos o modo Hidden ou muito oculto (Com este recurso as abas do Excel ficam muito escondidas e não podem ser reexibida pelo usuário ou através da opção Reexibir. Somente através de você ou usando o Editor do Visual Basic.
Sub HideActiveSheet()Dim myChoice as StringIf ActiveWorkbook Is Nothing Then Exit SubmyChoice = MsgBox("Do you want the active sheet to be Very Hidden ? ", vbQuestion + vbYesNoCancel)Select Case myChoiceCase vbYesActiveSheet.Visible = xlSheetVeryHiddenCase vbNoActiveSheet.Visible = xlSheetHiddenCase vbCancelExit SubEnd SelectEnd Sub
Tags: VBA, Excel, worksheet, hide, oculto
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhU0rFC0g1bEoAXTFqfQcLlu3NssmweFvXr9nZVB5CqjnLz4spJfZvmBdI_IpeVlnnVLPnZQz0zD_jKNDRmfV2HHg3YKLg2eVAnRTYyfXncYlX0rU6Lv4qycd2tLaUO-RAWWaaA-98AvbmY/s640/VBA_Signature_Andre_Luiz_Bernardes_032b-722457.png)
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhU0rFC0g1bEoAXTFqfQcLlu3NssmweFvXr9nZVB5CqjnLz4spJfZvmBdI_IpeVlnnVLPnZQz0zD_jKNDRmfV2HHg3YKLg2eVAnRTYyfXncYlX0rU6Lv4qycd2tLaUO-RAWWaaA-98AvbmY/s640/VBA_Signature_Andre_Luiz_Bernardes_032b-722457.png)
Nenhum comentário:
Postar um comentário