View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mark Stephens Mark Stephens is offline
external usenet poster
 
Posts: 124
Default DisplatAlerts doesn't work

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 = Flase 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