Set formula for a cell w/o reference to filename

Hi All.
I have 2 files opened. WBM (WorkBookMaster) & WBU(WorkBookUpdating). Users are currently using WBU. WBU is being updated with new stuff from WBM. When I created WBU, I pass protected the VBA Project so I cannot automate adding a new module. For the users to update WBU, I will instruct them to open WBM from a link and run a macro in WBM from WBU to add the new functionallity. NOTE WBU is protected, so I know where everything is and what all the sheet codenames are.

I am trying to put a formula in a cell in WBU.

Please Login or Register  to view this content.

NOTE: UDF Return_Sheet_Name_From_Passed_Codename("Sheet13") runs correctly. Sheet13 code name is passed and Assembly1 is returned, which is correct.
Resulting formula in WBU
='[GCM.xlsm]Assembly1'!B1
Result intended:
=Assembly1'!B1
The results turns out to have a reference to WBM file name: (I guess it is because the macro is running from that file???). How do I eliminate the reference to [GCM.xlsm]

Thanks
Steve

I have a workaround that is a solution... This works, but is not a solution to the original post..
Workaround is: Create a named range in WBU. Then set the formula to the named range.

Please Login or Register  to view this content.