View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
EagleOne EagleOne is offline
external usenet poster
 
Posts: 68
Default 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