View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
OffDev OffDev is offline
external usenet poster
 
Posts: 5
Default Attempting to call a sub from another wb using a Userform option b

Please assist.

I have an userform that has several options button each calls a sub proc
from another workbook
I am getting run-time error 1004 Method Run of object_Application failed
when I click on the button when the other workbook close .

When the workbook is open I am getting run-time error 1004 Cannot run the
macro wbMain.xlsm!cmdOpenfile. The macro may not be available in this
workbook or all macros may be disabled.but with a different reason.
My macros options are enabled and has trusted access.

I am baffled because the code is very simple:

Application.run "wbMain!subproc"

Thanks
Offdev