I need to create some code to prompt a user to provide a password to save/save as. I have a costing model on excel which needs to be shared by our sales reps. on our network server, but not saved anywhere else.
Apologies if already posted, but i have been trawling the site and found nothing suitable
Thanks in advance
The Cat
I think this is what you want. It asks the user for a password right before the file is saved. Put it in the thisWorkBook object of VBA.
Please Login or Register to view this content.
Bob
Click my star if my answer helped you. Mark the thread as [SOLVED] if it has been.
Thanks Blane
Although this code askes for the same password to open and the prompt to save can be cancelled and the file saved anyway
here's a version that allows you to cancel the save. The first executable line will skip
asking for a password if there already is one. You can comment that out if you wish.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks