VBA macro in Excel

[A Pretorius]

I need an explanation of an error message "Run-time error '-2147319784
(80028018)': method of 'Activate' of object '_Workbook' failed". Basically,
this is an Excel file with VBA macros that will not run.

 

[paul.robinson]

Hi
The error messages in themselves are often not very useful. Better to
show us the code and which line is highlighted when the error occurs.
regards
Paul

 

[A Pretorius]

The row with the arrow is the selected text.

Range("A9:A16").Select
Selection.RowHeight = 30
--->ActiveSheet.DrawingObjects("Dropdown 34").Select
Selection.Height = 27
Range("A17:B17").Select
Selection.RowHeight = 100

The problem is the error message varies with which machine one uses. This
is the selected text from my machine.

Thanks