Save and Print Button without duplicates and security password predefined.

[BleuDrache]

Hi ... I'm pretty new here, and I do hope and doing this in the right way, so, here goes my problem:

I want to insert a button in one of my files, which is sort of a protocol that I have to keep tracking for tracebility purposes. I would like this button to save a copy of this document with an unique name, which is in one of the cells of the workbook, and at the same time, print out a copy of the whole sheet in which that cell is. I've seen this thread: http://www.excelforum.com/excel-prog...ne-button.html, but it doesn't fully gives me what I need.

Trying to narrow it all: I need to program a button that once clicked, saves the file in a predetermined folder in my desktop, with an unique file name that should be composed of the content on one cell(say, "M-123456") plus another cell ("0001"), so, at the end, the saved file name should be: "M-123456 0001.xls". It should not create duplicates, or alert me if I tried to do it. Once this file is generated, it should have a predefined password (so it's the same for all the files generated from this original file) and inmediatly print the sheet this button is in.

Could it be possible? Am I dreaming or could it be done? I've tried a couple of things myself, but I've noticed that I failed miserably at it

I do thank you for your time

[Arkadi]

Do you have a workbook or existing code to share?

In any case, add this code to a module in the workbook, and then assign the macro to a button you insert on the sheet. Please note that cells B1 and B2 on "Sheet2" are where the code gets the file name parts from, but you can easily change the code to suit. I made the file extension xlsm instead of xls because that is a macro-enabled workbook which you need if you want a macro in it. Hope it helps

p.s. this code will give you an error if the folder does not exist, you can probably find code to make the folder if needed, but I wasn't sure how you want to handle that, and assume you will create the folder to save backups in.

Please Login or Register  to view this content.

[BleuDrache]

It does help :D! Thanks, Arkadi! Btw, could I ask one more thing? Besides requesting a password to access the file, could it be possible to ask for another password for the editing of such file? Thanks again :D

[Arkadi]

Sure, here is the updated code: I made the second password "second" but it could be the same as the first if you want....

Please Login or Register  to view this content.

[BleuDrache]

This was awesome, Arkadi, thanks for your help! Case Closed for me :D!