View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Trefor Trefor is offline
external usenet poster
 
Posts: 201
Default Assign macro broken after reference removed

I am in the middle of trying to convert my file from a permanent reference to
using RUN. In the main spreadsheet are a number of userform buttons which
call a macro (Sub Menu_New_Site) in one of the modules in the .xla. When I
have a reference set to the .xla the buttons work fine, if I remove the
reference I get the following error:

"The macro 'Menu_New_Site' cannot be found"

Any ideas?

--
Trefor