Good evening peeps,
I have a macro that displays a userform that allows users to export calculated cells to another spreadsheet in the same directory. This function has been working well - but now I want to implement a password to lock that second spreadsheet (so while users can add new entry to this second spreadsheet via the first one's userform, they cannot view or edit this second file by directly opening it). I attempted the code below but it still prompts for the password as I try to export it from the first spreadsheet.
Any idea would help! Thanks!
Bookmarks