| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel sheet protection
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel sheet protection
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 "Yazan Barakat" wrote: 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel sheet protection
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 "Yazan Barakat" wrote: 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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel sheet protection
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. "Mike" wrote: 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 "Yazan Barakat" wrote: 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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel sheet protection
gives run time error if a password already exists, if not it creats a new
password that i do not know "Mike" wrote: 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 "Yazan Barakat" wrote: 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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel sheet protection
Sheet1.Unprotect "Password"
Sheet1.Protect "Password" 'Password is the Password you can change to what you want "Yazan Barakat" wrote: gives run time error if a password already exists, if not it creats a new password that i do not know "Mike" wrote: 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 "Yazan Barakat" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ON AN EXCEL SPREAD SHEET TOOLS/PROTECTION/ (4TABS are not enabled | Excel Discussion (Misc queries) | |||
| in excel i want to make a sheet unprotected from the protection | Excel Discussion (Misc queries) | |||
| Excel Sheet Protection | Excel Discussion (Misc queries) | |||
| How do I remove the outline protection in Excel sheet? | Excel Discussion (Misc queries) | |||
| Sheet Protection & Grouped Columns in Excel | Excel Discussion (Misc queries) | |||
Linear Mode
