Use the IngoreReadOnlyRecommend argument to the workbooks.Open method:

IgnoreReadOnlyRecommended Optional Variant. True to have Microsoft Excel
not display the read-only recommended message (if the workbook was saved with
the Read-Only Recommended option).

workbooks.open "Mybook.xls", IgnoreReadOnlyRecommended:=True

--
Regards,
Tom Ogilvy


"dspilberg" wrote:

I have a macro that opens another file sent by someone I dont know. When the
macro opens that file there is a msgbox pop up telling me that the readonly
mode is recommended unless I need to change something.
I want to say NO to the Msgbox automatically, which means that I need to
make changes in that file and not open it in the readonly mode.

Do you have any suggestion?

Thanks.

Daniel (Brazil)