Скачать или смотреть UL-0006 | MS-Excel | Macro (Trading Journal) - 01 DEMO

UL-0006 | MS-Excel | Macro (Trading Journal) - 01 DEMO
Multiple Trading Account

:::::::::: Module: HideUnhideRibbon

Sub RibbonHide()
ActiveWindow.DisplayGridlines = False
ActiveWindow.DisplayHeadings = False
Application.DisplayFormulaBar = False
Application.DisplayFullScreen = True
End Sub

Sub RibbonShow()
ActiveWindow.DisplayGridlines = True
ActiveWindow.DisplayHeadings = True
Application.DisplayFormulaBar = True
Application.DisplayFullScreen = False
End Sub

:::::::::: MS-Excel Formula:

This week / Weekly trade results:
=IF(WEEKDAY(NOW())=2,NOW(),(NOW())-WEEKDAY((NOW())-2))

:::::::::: Hijri date format

Right-click
Format Cells ...
Number tab
Number
Click Custom - Type: B2m/d/yyyy

Thank you for viewing.