getactivesheetid() issue

[narendiran]

Hi All,

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.

[micheledenardi]

Hi,

try to put getactivesheetid() on a textbox and see which is the returned value when the bar became yellow.

Another things you can try is to put your formula in uppercase like:

if (upper(GetActiveSheetId())='DOCUMENT\DASHBOARD',Red(),Blue())

hope it helps