It seems there was some confusion regarding my previous thread that was closed, which can be found here:
http://www.excelforum.com/excel-prog...ml#post2390707

My original question is the same:
Is there a way to copy/get the "comments" of a cell using an excel formula?
i.e. if A1 contains a comment, copy that comment to B1?

What I meant by "locked" in the previous thread is that the VBA portion is locked out, and therefore I cannot run the macro within that specific file. The intent is not to crack the password, or get around password protection (in the sense of maliciously accessing data).
I can easily just copy and paste all the cells from the VBA-locked file and then copy it into my new file, but because this locked file is constantly being updated, I can't have a current update report without the "human macro" of copying and pasting these cells.