LinkBack URL
About LinkBacks
Hi,
I'm trying to make a Save As macro that has all of the following:
* Adds "P-" to the beginning original file name
* Adds a password to open the file
Please help!! Thank you in advance!
SaveAs Macro
Hi,
I'm trying to make a Save As macro that has all of the following:
* Adds "P-" to the beginning original file name
* Adds a password to open the file
Please help!! Thank you in advance!
Hello sumitomo,
This macro will save the ActiveWorkbook as the original name prefixed with "P-" and adds a password. Change the password in the macro to what you want to use.
Please Login or Register to view this content.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Thanks Leith!
I can't seem to get the file to save or have a password... maybe its me, lol.
I am using Excel 2007 if that makes a difference?
Hi sumitomo;
How are you triggering Leith's Sub()?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks