J
Jon
Could anyone tell me how to use VBA (Excel) to open a file but DISABL
macros as it does.
An old Excel 97 workbook has a worksheet.calculate formula that resize
columns; but it keeps crashing the macro.
Private Sub Worksheet_Calculate()
Cells.Select ' <-- This crashes the macro in 2003 but not '97?!
Cells.EntireColumn.AutoFit
...etc.
What I'd like to be able to do is to open their file but disable thei
<old> macros.
bit like this
workbook.open := "blah blah" Macrodisable = TRUE
or something like that.
Pls help
macros as it does.
An old Excel 97 workbook has a worksheet.calculate formula that resize
columns; but it keeps crashing the macro.
Private Sub Worksheet_Calculate()
Cells.Select ' <-- This crashes the macro in 2003 but not '97?!
Cells.EntireColumn.AutoFit
...etc.
What I'd like to be able to do is to open their file but disable thei
<old> macros.
bit like this
workbook.open := "blah blah" Macrodisable = TRUE
or something like that.
Pls help