Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Bypass Auto_Open
I think that I should be able to bypass an Auto_Open macro by holding down
Shift while opening the workbook. However, I have this Auto_Open macro: Sub Auto_Open() Workbooks.Open FileName:="C:\MyFile.xls" Rows("1:14").Select Selection.Delete Shift:=xlUp Selection.End(xlDown).Select ActiveCell.EntireRow.Delete Selection.End(xlUp).Select ActiveCell.EntireRow.Delete Range("A1").Select ActiveWorkbook.SaveAs FileName:="C:\MyFile2.xls", FileFormat:=xlNormal, Password:="", WriteResPassword:="", ReadOnlyRecommended:=False, CreateBackup:=False ActiveWindow.Close 'close Excel Application.Quit End Sub Even when I hold down Shift, the macro runs the first line: Workbooks.Open FileName:="C:\MyFile.xls" How can I keep it from running even this much when I open the workbook having the macro in it? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Bypass Auto_open Macro in Excel 2007 | Excel Discussion (Misc queries) | |||
Holding Shift to bypass Auto_Open doesn't work in Excel 2007... | Excel Programming | |||
how to bypass password?? | Excel Programming | |||
Bypass Worksheet_Change Sub | Excel Programming | |||
Bypass an | Excel Programming |