Hi

I am trying to have a command button automatically open some other excel workbooks, gather information from them and copy that information into my worksheet.

I have come across a workbook which has been set up to be 'READ ONLY' unless you provide a password. I do not have access to the password and would like to know what VBA command i should use to have it automatically select the READ-ONLY option when prompted. Is this the READONLYRECOMMEND property? I've tried a couple of variations with that but had no success.....

Any help would be much appriciated.

Emm100