Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protected Sheet and allowing External Data Refresh
Hi
I posted this in PE Worksheets, but was advised to try here. here is my query. I have protected my worksheet to stop users from chaning information, but now the Refesh External Data does not run. I need to unlock the worksheet to run it, but i don't want the users to do this. Is there a way to enable the refresh data while the worksheet is still protected? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protected Sheet and allowing External Data Refresh
if the refresh is forced by a macro (ie VBA) you could possibly unprotect
the sheet before refreshing then protect it again afterwards? "ssdsibes" wrote in message ... Hi I posted this in PE Worksheets, but was advised to try here. here is my query. I have protected my worksheet to stop users from chaning information, but now the Refesh External Data does not run. I need to unlock the worksheet to run it, but i don't want the users to do this. Is there a way to enable the refresh data while the worksheet is still protected? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protected Sheet and allowing External Data Refresh
Hello:
I have a similar issue and I am unable to get the data refesh/update - can somebody please advice? The code that I am using is: Private Sub Workbook_Open() With ActiveSheet .Unprotect Password:="test2" ActiveWorkbook.RefreshAll ActiveSheet.Protect Password:="test2", _ DrawingObjects:=False, Contents:=True, Scenarios:= _ False, AllowFormattingCells:=True, AllowFormattingColumns:=True, _ AllowFormattingRows:=True, AllowInsertingColumns:=True, AllowInsertingRows _ :=True, AllowInsertingHyperlinks:=True, AllowDeletingColumns:=True, _ AllowDeletingRows:=True, AllowSorting:=True, AllowFiltering:=True, _ AllowUsingPivotTables:=True End With End Sub I get the error saying data can not be refreshed - unprotect the sheet!! I have the Background Refresh and Refresh on Open UNCHECKED. Thank you. Forge "Patrick Molloy" wrote: if the refresh is forced by a macro (ie VBA) you could possibly unprotect the sheet before refreshing then protect it again afterwards? "ssdsibes" wrote in message ... Hi I posted this in PE Worksheets, but was advised to try here. here is my query. I have protected my worksheet to stop users from chaning information, but now the Refesh External Data does not run. I need to unlock the worksheet to run it, but i don't want the users to do this. Is there a way to enable the refresh data while the worksheet is still protected? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Refresh Pivot table data in Protected sheet | Excel Discussion (Misc queries) | |||
Allowing insert picture on a protected sheet | Excel Discussion (Misc queries) | |||
Allowing for Grouping and Ungrouping while Sheet is Protected | Excel Programming | |||
Allowing hyperlinks an a protected sheet | Excel Discussion (Misc queries) | |||
refresh external data on a protected sheet | Excel Discussion (Misc queries) |