Excel 2007 Run-Time error

M

Marilyn

I have a user in my group that created a macro that updates the data based on
the pivot table. The Pivot table is hidden and the macro runs fine when the
worksheet is not protected but once he protects the worksheets and tries to
run the Update macro he gets the "Run-time error 1004;

The code for the macros looks like:
' Update_Form Macro
'

'
Range("V30").Select
ActiveSheet.PivotTables("PivotTable4").PivotCache.Refresh
Range("V46").Select
ActiveSheet.PivotTables("PivotTable2").PivotCache.Refresh

End Sub

Any thoughts why protecting the sheet gives out that error?
 
P

Per Jessen

Hi

You have to unprotect the sheet before you can refresh the Pivot table.

sub Refresh()

Activesheet.unprotect Password:="JustMe"

'Your code to Refresh to Pivot table

ActiveSheet.Protect Password:="JustMe"
End sub

Hopes this help
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Pivot Table Error 1
Macro works on some but not for all 0
Using macro to switch 'page' in a pivot table? 1
Don't want to hard-code file name in macro 3
Run-Time error '1004: Unable to get the PivotTables property of the worksheet class 4
Error 2007 0
Run-Time error 1004 Application defined or object defined error - 0
rt error 1004 0

Top