Telegram Group & Telegram Channel
Macro para colocar a planilha em tela cheia e tela normal:

Sub Apresentar_on()
Application.ExecuteExcel4Macro "SHOW.Toolbar(""Ribbon"", False)" 'Oculta todas as guias de menu
Application.DisplayFormulaBar = False 'Ocultar barra de fĂłrmulas
Application.DisplayStatusBar = False 'Ocultar barra de status, disposta ao final da planilha

With ActiveWindow
.DisplayWorkbookTabs = False 'Ocultar guias das planilhas
.DisplayHeadings = False 'Oculta os tĂ­tulos de linha e coluna
End With

End Sub

Sub Apresentar_off()
Application.ExecuteExcel4Macro "SHOW.Toolbar(""Ribbon"", True)" 'Reexibir todas as guias de menu
Application.DisplayFormulaBar = True 'Reexibir barra de fĂłrmulas
Application.DisplayStatusBar = True 'Reexibir barra de status, disposta ao final da planilha

With ActiveWindow
.DisplayWorkbookTabs = True 'Reexibir guias das planilhas
End With

End Sub



tg-me.com/tudocomexcel/1562
Create:
Last Update:

Macro para colocar a planilha em tela cheia e tela normal:

Sub Apresentar_on()
Application.ExecuteExcel4Macro "SHOW.Toolbar(""Ribbon"", False)" 'Oculta todas as guias de menu
Application.DisplayFormulaBar = False 'Ocultar barra de fĂłrmulas
Application.DisplayStatusBar = False 'Ocultar barra de status, disposta ao final da planilha

With ActiveWindow
.DisplayWorkbookTabs = False 'Ocultar guias das planilhas
.DisplayHeadings = False 'Oculta os tĂ­tulos de linha e coluna
End With

End Sub

Sub Apresentar_off()
Application.ExecuteExcel4Macro "SHOW.Toolbar(""Ribbon"", True)" 'Reexibir todas as guias de menu
Application.DisplayFormulaBar = True 'Reexibir barra de fĂłrmulas
Application.DisplayStatusBar = True 'Reexibir barra de status, disposta ao final da planilha

With ActiveWindow
.DisplayWorkbookTabs = True 'Reexibir guias das planilhas
End With

End Sub

BY 📊 Tudo com Excel


Warning: Undefined variable $i in /var/www/tg-me/post.php on line 283

Share with your friend now:
tg-me.com/tudocomexcel/1562

View MORE
Open in Telegram


Tudo com Excel Telegram | DID YOU KNOW?

Date: |

How to Use Bitcoin?

n the U.S. people generally use Bitcoin as an alternative investment, helping diversify a portfolio apart from stocks and bonds. You can also use Bitcoin to make purchases, but the number of vendors that accept the cryptocurrency is still limited. Big companies that accept Bitcoin include Overstock, AT&T and Twitch. You may also find that some small local retailers or certain websites take Bitcoin, but you’ll have to do some digging. That said, PayPal has announced that it will enable cryptocurrency as a funding source for purchases this year, financing purchases by automatically converting crypto holdings to fiat currency for users. “They have 346 million users and they’re connected to 26 million merchants,” says Spencer Montgomery, founder of Uinta Crypto Consulting. “It’s huge.”

Tudo com Excel from us


Telegram 📊 Tudo com Excel
FROM USA