I have a button in a workbook in order to export each tab to its own workbook. When the sheet is exported it remains protected. Is there a way to have the sheet automatticaly change to unprotected when its exported? not sure if i can incorporate this function into the current macro (below) by adding my password into it somehow?? any help would be much appreciated!

Please Login or Register  to view this content.