If I open the file up from the server I'm prompted about being in read-only and the edit button appears. if I open this same file from a desktop shortcut I don't get the prompt and I'm in readonly always. Any idea why this is? Can I add code along the lines of:

Private Sub Workbook_Activate()
ActiveWorkbook.ChangeFileAccess Mode <> ReadOnly
End Sub