Hello,
I can Adjust Hijri Calendar (Add/Subtract one or two days) in Window by Changing the registry key using the following VBA Code
Sub HijriAdjustmentDate()
Dim wsh As Object
Set wsh = CreateObject("WScript.Shell")
wsh.RegWrite "HKEY_USERS\S-1-5-21-4059124821-1674896164-3570628022-1001\Control Panel\International\AddHijriDate", "AddHijriDate+2", "REG_SZ"
Set wsh = Nothing
End Sub
But this doesn't affects Hijri Dates in Excel.
How Can I Adjust The Hijri Calendar days in Excel using VBA?
Hint:
About : AddHijriDate Using Registry key modificaition
https://learn.microsoft.com/en-us/wi...s/addhijridate
I Found this article about Hijri Date Adjustment
https://learn.microsoft.com/en-us/do...ijriadjustment
How Can apply this / or something like this using excel vba?
Bookmarks