Please let me know whether I can edit the header and footer if the worksheet is locked.
If the worksheet has been locked for editing, no.
Suppose I can't do this then how do I insert the document no in such a way in the worksheet that it automatically displays in all the pages of the worksheet.
These are very cumbersome workaround's, but they might work.
- Firstly, can you not get the worksheet unlocked? What version is it? Some members in the old forum where able to unlock sheets.
- If the file is printed to *.pdf and you have Acrobat you could insert the document number then.
- Create the document number in a text file in Mathcad and have it at the bottom of each page. If the worksheet is locked for editing you are allowed to change the page margins - reduce them so they cut the header and footer off.
Mike
I don't think that's quite true. I don't recall anyone saying they knew how to unprotect the worksheet. Even if they did, it probably would only apply to worksheets created in version 2001 or earlier.
Maybe that is what I meant. 
I, and a couple of others, know how to unlock collapsed areas. For worksheets saved using version 2001i or later there are some specific requirements for that to be possible though, one of which is that the worksheet is not protected for editing.
Care to share the secret? 
Mike
Care to share the secret?
Sorry, no. And especially not on a public forum. I figured it out for myself, and I believe both of the others did too. So as far as I know, nobody has shared it. Locked areas are there for a reason, and I am not going to invalidate that by disclosing how to open them.
I think that depends on the nature of the project and why the page numbers were not added before the worksheets were protected. If, say, it's a design for a bridge that has been approved at multiple levels, and the worksheets then locked, there is no way I would be the person that modified those worksheets in any way at all. If the bridge then had a problem, guess whose door they would be knocking on!
This is usually the problem especially within the Engineering sector. We have multiple programs which have where written many years ago by Engineers who have since left. These programs where sent out to be externally verified by industrial recognised companies, but as time goes on the standards the programs where wrote in accordance with have been superseded or new recommendations are found.
Even if the worksheet is modified the calculation or results produced should go through an internal checking process and ultimatley the books stops with the 'Approved signature' - Engineering manager.
Mike
ultimatley the books stops with the 'Approved signature' - Engineering manager.
Unless the engineering manager points the finger right back at you and says "he told me he hacked the file to change the page numbering, and maybe he also changed something else". Then they tie you into a chair, shine bright lights in your face, and starting asking questions: "Mr Armstrong; please explain why you hacked the file! Why did the cable drum buckle, resulting in the ship sinking with the loss of all hands? What part did you play in that, Mr Armstrong? Do you know what water-boarding is Mr Armstrong? If you don't answer our questions the way we want them answered, you might have first hand knowledge of that soon Mr Armstrong!".
Unless the engineering manager points the finger right back at you and says "he told me he hacked the file to change the page numbering, and maybe he also changed something else". Then they tie you into a chair, shine bright lights in your face, and starting asking questions: "Mr Armstrong; please explain why you hacked the file! Why did the cable drum buckle, resulting in the ship sinking with the loss of all hands? What part did you play in that, Mr Armstrong? Do you know what water-boarding is Mr Armstrong? If you don't answer our questions the way we want them answered, you might have first hand knowledge of that soon Mr Armstrong!".
Class.
Then again the EM would probably say he didn't know I had changed the 'Approved Mathcad program' - WALK THE BLANK MIKE
Mike
Mathcad document protection unlock procedure:
1) save document as *.xmcdz;
2) open new xmcdz-file as archive and copy from its content (enhancementless);
3) open dearchived file in any text redactor and by force of CTRL+F find textline with word password;
4) finded textlin deleted, then CTRL+S;
5) “modificated” file inserted back into xmcdz-file(archive);
6) open xmcdz-file in Mathcad - voilà
Mathcad document protection unlock procedure:
1) save document as *.xmcdz;
2) open new xmcdz-file as archive and copy from its content (enhancementless);
3) open dearchived file in any text redactor and by force of CTRL+F find textline with word password;
4) finded textlin deleted, then CTRL+S;
5) “modificated” file inserted back into xmcdz-file(archive);
6) open xmcdz-file in Mathcad - voilà
Could you elaborate on the steps required to unlock?
Mike
