protect workbook

Hi all I'm having a problem, and after many hours searching for a solution, i desidet to ask in here. What im looking for is a macro which does: When i close my workbook it should password protect some specific sheets, the workbook structure and then hide some of the sheets. I simply can't...

Hi, I have a Workbook that users should be able to open and work on. But users shouldn't be able to save the workbook on their computer. How can I add a password protection when someone clicks Save As and Save? I included the code below to the Excel Object "This workbook" but it's not working...

Hi all, I have written 3 separate macros in a protected workbook which are running successfully, however I have 2 additional functions that I'm unable to get working. I have explained below what my macro does (in a nutshell) to give context to what I need to add in. 3 existing macros I am...

Hi, I'm new to this macro. I found following macro to protect sheet in a folder. But somehow it's not working or i am not getting results. Can you please help where might be wrong. Sub ProtectAllSheets() Const myPassword = "random" Dim sh As Worksheet Dim wBk As Workbook Dim...

Hi, I Need help in to protecting sheets in multiple workbooks in a particular folder. With a particular password 1st i would like to protect sheets from editing in multiple work books in a folder. I also need to provide a different password to open that work book. It's like with a password...

Hello All, I have a Excel sheet that I need to lock from editing if the current date is past 3/31/16. however if there is a "password" typed into "Setup!A12" then this would be ignored, then the code would need to see if the date has passed 7/31/16 then check "Setup!A12" for a different...

Hi, I have the below macro in my workbook however due to increased number of SQL queries and the fact I need to enter the password for them all it appears the macro locks the sheets before the data is refreshed. Excel pops up with a message that says the data can not be refreshed as the sheet...

Hi all, I'm looking for a way to customise what gets locked when I protect an Excel workbook. For instance, I'd like users to be able to copy/delete certain worksheets, but not be able to unhide/delete other sheets. Is this possible? Many thanks, Grace

Hello, I am continually running into an issue when trying to protect my workbook with macro's I have a workbook with 12 sheets. Upon workbook_open, I hide them all, except the first which is protected completely, no one can even click on a cell. At the end of the code, I protect the workbook...

So i have this lovely workbook that I need to protect. Simple solution would be just to protect the workbook however when I do that it's disabling the part of my Pivot table that allows you to double click on an item and it gives you all the items on a new sheet. Now I'm thinking maybe I...