Author would like you to open as read only - How to select 'No'

[dluhut]

Hello Excel VBA experts,

Below is part of a macro that I've wrote to open the workbook. This macro works fine IF user didn't check 'Read only recommended' under 'General Option' when he/she saved the file.

Please Login or Register  to view this content.

May I know then, how can I open the workbook AND if there's an option to ask "Author would like you to open as read only", it automatically select as 'No' so that my macro can open, edit and save the workbook. Instead of opening it as a 'Read Only'

Solved: Was able to use one of the parameters 'IgnoreReadOnlyRecommended' and set it to True so that I can open NOT as a read only.

Please Login or Register  to view this content.