Hi unknown,


-----Original Message-----
The problem is, in workbook A I have code that opens
workbook B - K. In each
of the workbooks B - K they then open a further number
of workbooks that the
users input to to update themselves with the most current
info. The code I

that looks like a real problem, because every workbook
that opens another workbook will ask you to open it read-
only...


have in workbooks B - K has diplayalerts and
screenupdating as false and if
run seperately I have no problems.

Are you sure that if you run these workbooks they will not
ask you how to open the linked workbooks? I hardly can
imagine that, because if a workbook is already open by
another user and you try to get data from it excel will
show you this message not caring about the screenupdating
(because without knowing if excel should open it readonly
excel will not open it)



The messages appear when trying to run it all through
workbook A to get an
overall view of what's been input.


Nevertheless, I think you can just use the UpdateLinks
statement to change that situation... and I think you need
to include this in every of the worksheets B-K (in every
worksheet that needs data from another worksheet which may
be opened already by another user)

PS: why posting with your real name? Because its usual and
more personal, I think...


Best

Markus


I know this is a bad set-up, but I've been asked to set
this up at varying
stages and now to go back to the start and modify it all
to run this big
overview is a very big task! I just wondered if there was
a reason I was
getting the Read Only etc messages??





"Markus Scheible" wrote:

The thing is that you have to give something back to
that
window - otherwise the workbook wouldnt open - so excel
asks you even if you turned the window.updating to
false...

but with the open dialog you can also give the command
to
open it read-only by:

Workbooks.Open FileName:="abcd.xls", ReadOnly:=True

for Read-Only:

Optional Variant. True to open the workbook in read-
only
mode.


.