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!
Bookmarks