Rename Workbook and Macro Dies!! HELP!!

G

greenfalcon

Hi im having one last problem, i realized that my fellow employees wil
want to rename their timesheets, right now if they do so my macros sto
working because they are trying to open up a macro that it cant find
here is the code, i need it to open the activeworkbook, macros
HELP!!!

here is the incorrect code

Application.Run "Tmsht_2004_Standard_Hourly.xls!UPsheet"
Application.Run "Tmsht_2004_Standard_Hourly.xls!add_row_overhead"
Application.CutCopyMode = False
Application.Run "Tmsht_2004_Standard_Hourly.xls!Psheet"

Someone might change the name from standard_hourly to, bobs_timesheet.

i need the macros to work no matter what the workbook is named.

Thanks

Please help

Jaso
 
Top