I have an issue with GetActiveSheetId().
if (GetActiveSheetId()='Document\Dashboard',Red(),Blue()). It works most of the time but sometimes it goes blank and gives Yellow default colour on the bar chart. Does any came across this issue in the past?
Please help me out if there are any quick fix.