Worksheet protection

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

FatBytestard

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?

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.
 

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