I have assigned macros to option buttons in a sheet. All
works well in the original worksheet. When I update the
sheet and save it under another filename, then email it to
me, the macros don't work.

The error I get is filename Event_Calendar.xls can not be
found. The name of the new sheet is
Event_Calendar_v26.xls.

I edit the macro toolbar options and look at assign, the
full pathname is displayed...

'D:\Profiles\tmac\Local Settings\Temporary Internet
Files\OLK13\Event_Calendar.xls'!DB_Filter_NextQ

If i delete the pathname and leave just the macro name of
DB_Filter_NextQ, the macro now runs. I then look at the
pathname again, it is now prefaced with the filename.

Is there a way to hardcode the macro to the local
reference only?

thanks

tim macklenar