Without seeing a sample workbook, it is not easy to provide a solution, but have you tried using the container for worksheets?
and the below link as well
Hope this helps
Unfortunately I am not allowed to sent you a sample.
Yes, I have use the objects, i forgot to mention that my worksheets are floating in the dashboard. Anyway with or without the objects the worksheet just gets empty not hidden.