Worksheet protection

  • Thread starter Thread starter ssdsibes
  • Start date Start date
S

ssdsibes

Hi
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?
 
Hi
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?
Click to expand...

If I am not mistaken, with a macro, you can explicitly unprotect a
sheet, call the refresh, and reprotect the sheet that contains the pivot
table or such.

I recall reading about it here (in the programming group) some
weeks/months back, but I do not recall the syntax of it.

You should ask this in m.p.e.programming, instead of
m.p.e.worksheet.functions.
 
Back
Top