Hi all!
I have a question regarding Macros. I have a spreadsheet that I am working on for work and want to insert a button, "Lock" and another, "Unlock" When pressing the Lock button, I want for the entire spreadsheet to be protected. When pressing the Unlock button, I want for a window to come up where the user can enter the password which will unlock the entire spreadsheet. I have tried a lot of things but I cant seem to get a pop up window to unlock the spreadsheet. Any help would be GREATLY appreciated.
I have a question regarding Macros. I have a spreadsheet that I am working on for work and want to insert a button, "Lock" and another, "Unlock" When pressing the Lock button, I want for the entire spreadsheet to be protected. When pressing the Unlock button, I want for a window to come up where the user can enter the password which will unlock the entire spreadsheet. I have tried a lot of things but I cant seem to get a pop up window to unlock the spreadsheet. Any help would be GREATLY appreciated.
