Hi,

I was wondering if someone could help me ? I am opening a read only workbook from this I need to make one of the sheets active and search for a specific name. When I run my code the workbook is opened and the sheet I want to be active appears active but when I search for the specific name the code searches on the sheet with the code behind it not the active sheet. Is this something to do with the workbook being read only?

Thanks for looking