How would I re-write the following code to work with an "On open Password" prompt?
Please Login or Register to view this content.
How would I re-write the following code to work with an "On open Password" prompt?
Please Login or Register to view this content.
I mean this alone works perfect:
But I would need to add a password based on what is in my Sheets("Control").Range("K2")Please Login or Register to view this content.
I havent' found anything yet online.
Hi, Excelnoub,
if you want to SaveCopyAs there is no chance to do what you want, you would need to use SaveAs for that. You may look up the commands in the VBA Help/Object browser.
Ciao,
Holger
Last edited by HaHoBe; 05-15-2014 at 12:40 PM. Reason: typos - more than I can bear :(
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
Thank you HAHoBe
I mean, I got the following:
The thing I don't like is that my Current Workbook is being closed and activate the new one... The SaveCopyAs made it simple as it would just make a copy of that workbook then it would close it while I was still able to work within my "Master Template".Please Login or Register to view this content.
Hi, Excelnoub,
what is saveminusone?
You will store the fullname of the template, use saveas and return by opening the original workbook before closing the newly created one.Please Login or Register to view this content.
Ciao,
Holger
Will try and do this
saveminusone is:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks