Excel sheet protection

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i have an excel sheet that contains a pivot table that i would like to
protect to avoid selecting locked cells but when i do so i can not refresh
the data of the pivot table!!!
What shall i do
 
you could create a macro like this that will uprotect then refresh then
protect sheet
without a password
Sub refresh()
ActiveSheet.Unprotect
ActiveWorkbook.RefreshAll
ActiveSheet.Protect
End Sub
 
This way you could use a password
Sub refreshwithpassword()
Application.ScreenUpdating = False
Sheet1.Unprotect "Password"
ActiveWorkbook.RefreshAll
Sheet1.Protect "Password"
Application.ScreenUpdating = True
End Sub
 
Thank you Mr. Mike the solution is partially valid, when i run the macro it
refreshs correctly but when it reprotects it changes the user allowable
options so he will not be able to filter the results.
 
gives run time error if a password already exists, if not it creats a new
password that i do not know
 
Sheet1.Unprotect "Password"
Sheet1.Protect "Password" 'Password is the Password you can change to what you
want
 

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

Refresh Pivot table data in Protected sheet 3
Refresh Pivot table data in protect sheet 2
Refresh pivot table on protected sheet 3
Pivot Table - Changes 5
Refreshing Pivot Table on a protected spreadsheet tab 1
how to partially protect a pivot table based worksheet 8
Pivot Table update 8
Protect part of pivot table 1

Back
Top