Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Thanks for that, good workaround,
rgd, Mark "Ken Macksey" wrote in message ... Hi One way around it is to use another workbook to open your read only workbook. Use code like this in another blank workbook that does nothing but open your read-only workbook. Private Sub Workbook_Open() Application.DisplayAlerts = False Workbooks.Open "your_workbooks_name.xls" End Sub HTH Ken |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
DisplayAlerts and ScreenUpdate will not set to False | New Users to Excel | |||
DisplayAlerts = False fails | Excel Programming | |||
Can't Set DisplayAlerts to False | Excel Programming | |||
Can't Set DisplayAlerts to False | Excel Programming | |||
Can't Set DisplayAlerts to False | Excel Programming |