protected workbook

Hello, I have a project requiring the use of PivotTables in a protected Workbook. I need to code a macro that will allow users to drill down into the PivotTable values, and then will automatically delete them once the book has been closed. I have found plenty of threads demonstrating how to do...

Hi All I am hoping that someone can help me. I am attempting to open an excel file which needs a password at start up. I have tried using the code below: "Sub OpenWbWithPassword() Application.DisplayAlerts = False Workbooks.Open Filename:="S:\Site\Training...

Hi, I have found the following code on the Internet which has allowed me to protect all the formulae in a Workbook, however, I need to be able to unhide any column or row to view without removing the password protection. Could someone, please help me modify the code below to allow this for me...

Hi, I'm trying to allow the users to edit objects(ie text boxes in this case) in a protected workbook. I followed the instructions behind the link below, so locked certain cells and continued to protecting the sheet. Everything works perfectly until I save & close the workbook. After i reopen...