Thread: Determine Workbook Mode
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mike H. Mike H. is offline
external usenet poster
  
Posts: 471
Default Determine Workbook Mode
The first line in this if-statement is incorrect. What would be the correct
syntax?

If ActiveWorkbook.Mode < xlReadOnly Then
ActiveWorkbook.ChangeFileAccess Mode:=xlReadOnly
End If

Reply With QuoteReply With Quote