Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Method 'MacroOptions' of object'_Application' failed Runtime Error 1004
Note to the Google Search Group
There are at least two explanations for the subject error message: Most often it occurs when one places VBA code in the ThisWorkBook module when it should be in the General Module Also, if you have the same-named macro in two modules of the same VBA project AND you then attempt to execute an "Application as object" macro like: With Application .MacroOptions Macro:="PswdAdd", Description:="Passwords Add", _ ShortcutKey:="A" End With ' This will fail if you have a copy of the "PswdAdd" macro in ' another module in the same VBA application i.e. workbook. EagleOne |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Error: method 'select' of object_worksheet' failed | Excel Discussion (Misc queries) | |||
runtime error 1004 method range of object '_global failed | Excel Discussion (Misc queries) | |||
Method 'Add' of object 'CommandBarControls' failed | Excel Discussion (Misc queries) | |||
Help: runtime error - Method seriescollection object_chart failed | Charts and Charting in Excel | |||
Method 'Paste' of object '_Worksheet' failed | Excel Discussion (Misc queries) |