Macro Pathnames?
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
|