The code in your procedures run after the workbook is opened--so it's already
too late.

Mark Stephens wrote:
>
> I made my workbook read only so that users cannot select the chart on a
> chart sheet. Now when I open my workbook it displays a message:
>
> 'Workbook should be opened as read only unless you intend to save changes to
> it. Open as read only?'
>
> I put Application.DisplayAlerts = False in the OnOpen code first line but it
> wont go away. Does anyone know how to get rid of it ?
>
> Any help much appreciated, kind regards, Mark

--

Dave Peterson