That's something weird.
You can set up guides for the whole workspace or per artboard (select the artboard and then set up its guides). When not active the artboard guides are hidden and the other ones visible.
Also you can erase only guides from the active artboard.
But you cannot hide guides from active artboard…
Hope somebody will notify this to the Adobe developpers… You should fill a suggestion.