Should just open it readonly.

--
Regards,
Tom Ogilvy

"pauluk " wrote in message
...
What i require is quite simple.

I have created a macro which extracts data from specfic spreadsheets.
The spreadsheets are in constant use and i there need to know the
following:

If the macro automatcly opens the spreadsheet and no one else is using
it it will open normally, but if the macro opens the file and it is in
the read only box appears will the macro just go in as read only or
will i have to place code to tell the macro to go in as readonly?

If i require code can you please give an example


---
Message posted from http://www.ExcelForum.com/