Hi,

There are seveal macro based ways but if the user doesn't enable macros then
you have a problem. Why not simply set the file as read only by right click
in Windows explorer, select properties and set it as read only.

This can still be defeated but is probably as secure as any macro based
solution.

Mike

"Leanne M (Aussie)" wrote:

Hi,

I have a file which is to be viewed only.

I have got the code to close the workbook but I want to include the fact
that it should be closed without saving changes.

Is this possible?

My code for closing is simply

ActiveWorkbook.Close

Thanks


--
Leanne M (Aussie)
(Changed Display name from Leanne)
United Kingdom
(Don''t ask me what an Aussie is doing living in the UK!)