| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protect A Pivot Table
I'm back with another query!
I need to protect a pivot table so that users cannot alter any detail on the page, but also allow the table to refresh using VBA activate buttons. I could use the protect command in the macro of the button that take the user to the table, and then unprotect when they leave to allo future refreshes, But..... IS THERE A SIMPLER METHOD -- Message posted from http://www.ExcelForum.com |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Protect A Pivot Table
Refreshing a pivot table, for the most part, is an overt act. What causes
the table to refresh? If you are using code to do it, why not just unprotect the sheet, refresh the table, protect the sheet. -- Regards, Tom Ogilvy "Celtic_Avenger " wrote in message ... I'm back with another query! I need to protect a pivot table so that users cannot alter any details on the page, but also allow the table to refresh using VBA activated buttons. I could use the protect command in the macro of the button that takes the user to the table, and then unprotect when they leave to allow future refreshes, But..... IS THERE A SIMPLER METHOD? --- Message posted from http://www.ExcelForum.com/ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| PROTECT PIVOT TABLE | Excel Discussion (Misc queries) | |||
| Protect part of pivot table | Excel Discussion (Misc queries) | |||
| protect parts of a pivot table | Excel Worksheet Functions | |||
| Pivot table with protect workbook | Excel Discussion (Misc queries) | |||
| Protect and unprotect Pivot table | Excel Programming | |||
![Celtic_Avenger[_6_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
