Running macros including hidden worksheets

Hi all, im trying to run a macro to refresh a worksheet full of pivot tables to update all my graphs on a seperate worksheet. i want to hide the worksheet with the pivot tables on the the users cant see this, but when i run my macro it comes up with errors as the worksheet is hidden any ideas?

Have you tried to set the visible property of the sheets to 'Visible' at the start of the macro, have the macro do its thing and then set the visible property back to 'Hidden' at the end of your macro?

my macro at the moment is:

' Macro5 Macro
'
'
Sheets("PivotTables - DO NOT CHANGE").Select
ActiveWorkbook.RefreshAll
Sheets("DashBoard").Select
Range("C1").Select

End Sub

do you know what i would need to add to make it visible at the start of the macro and the end?

thanks, i updated the VBA with:
Sub Macro5()
'
' Macro5 Macro
'

Sheets("PivotTables - DO NOT CHANGE").Hidden = False
Sheets("PivotTables - DO NOT CHANGE").Select
ActiveWorkbook.RefreshAll
Sheets("PivotTables - DO NOT CHANGE").Hidden = True
Sheets("DashBoard").Select
Range("C1").Select
End Sub

and i had error 438 object doesnt support this property or method

My apologies. I made an error in my first post and then went back in and fixed it. Please have a look at post #4 again. The "Hidden" should have read "Visible".

That worked!!! brilliant thanks for all your help!

My pleasure.