Running Openoffice 3.2.0 on Linux Mint 9

I have a Calc spreadsheet set up to load an external data source (Base table) into one sheet, and on another sheet refresh some Datapilots all with macro's assigned to 'open document'. (I also have the macro's assigned to a key to manually refresh)

I would like to either hide or otherwise protect the sheet that loads the external data, but as soon as I protect it or hide it the refresh of the data source fails.

Anyone any ideas? Obviously if it's protected, the cells become read only, and if I hide it, the GoToCell seems to fail.

The code from the data refresh is:



dim document   as object
dim dispatcher as object

document   = ThisComponent.CurrentController.Frame
dispatcher = createUnoService("com.sun.star.frame.DispatchHelper")

dim args1(0) as new com.sun.star.beans.PropertyValue
args1(0).Name = "ToPoint"
args1(0).Value = "$DataImport.$A$1"

dispatcher.executeDispatch(document, ".uno:GoToCell", "", 0, args1())

dispatcher.executeDispatch(document, ".uno:DataAreaRefresh", "", 0, Array())