downloading excel file for open causes "file is locked for editing

H

HigherImpact

I have excel files that have visual basic code.

When these excel files are downloaded from the web and opened (they are
downloaded into a temporary folder and have a name like test[2].xls), we get
an error "file is locked for editing". When the file is downloaded and
saved, then opened, everything works fine.

Auto open works fine, but the error occurs when trying to call
RFRsummary_menu_add.

I have also tried calling RFRsummary_menu_add directly from auto open, but
that fails too.

Sub Auto_Open()
Application.Worksheets("RFR Summary").OnSheetActivate =
ActiveWorkbook.Name & "!Module1.RFRsummary_menu_add"
Application.Worksheets("RFR Summary").OnSheetDeactivate =
ActiveWorkbook.Name & "!Module1.RFRsummary_menu_del"
Application.Worksheets("RFR Details").OnSheetActivate =
ActiveWorkbook.Name & "!Module1.RFRdetails_menu_add"
Application.Worksheets("RFR Details").OnSheetDeactivate =
ActiveWorkbook.Name & "!Module1.RFRdetails_menu_del"
End Sub

Sub RFRsummary_menu_add()
MenuBars(xlWorksheet).Menus.Add Caption:="RFR Print"

MenuBars(xlWorksheet).Menus("RFR Print").MenuItems.Add _
Caption:="Print RFR Summary", _
OnAction:="Print_Summary"
End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding custom menus to existing excel application 0
Can't manually open file after coding. 0
File is locked for editing message 3
Workbooks w macros showing as "locked for editing by" 3
Excel "file locked for editing" 1
Events won't trigger if locked for edit and if opened from IE 4
How to stop: Microsoft XLS is locked for editing in 2003 Excel 1
excel file locked for editing. there's only me! how to unlock? 0

Top