View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] dingasm@worldnet.att.net is offline
external usenet poster
 
Posts: 3
Default Macro names in a Module

I've found that assigning a macro to a toolbar control employs the
filename as a prefix to the macro name. EX: myfile.xls!macro1. If the
workbook is renamed or a copy made with a different name, the controls
will continue to look for the macro in the original file. Is there any
way to limit the assigned name to the macro name only?