VBA Open Read Only Workbook With No Prompt

[Endeavouring]

Hi
I've been playing with this for ages but with no success.
I am using a workbook for users to use as a reference manual.
The workbook is read only.
When it is opened, I don't want it to display the read only options of "open as read only ? "yes", "No" "Cancel"
I just want it to open as read only without any user input.
Likewise,
When it is closed I do not want a prompt to Save the changes I just want it to close unsaved.

Any help appreciated

 

[Andrew Poulsom]

This may help you:

http://www.eggheadcafe.com/software/aspnet/31135605/no-prompt-for-read-only.aspx

 

[Endeavouring]

Cheers Andrew

I had looked at that one already but couldn't make it do what I needed.
Thanks for looking though.