Protected Sheet and allowing External Data Refresh

S

ssdsibes

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?
 
P

Patrick Molloy

if the refresh is forced by a macro (ie VBA) you could possibly unprotect
the sheet before refreshing then protect it again afterwards?
 
F

Forge

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
 

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

Top