I'd appreciate any tips as to a better way to deal with the following:

I am dealing with unprotecting and protecting some data in order to do
some updates to a worksheet. I want to find a way that VBA knows my
current filename so that I can avoid using the following:

Workbooks("Data_Apr2005.xls"). _
Worksheets("Cash Flow").Protect DrawingObjects:=False

Is there a way to specify the path the user opened the file from and
the filename without hardcoding the information?

Thanks!