protection

Other than password protecting each individual macro/ function/ procedure in my VBA code, is there any way to prevent users from running macros from their Developer tab? I would like them to only be able to run macros from command buttons or a custom toolbar, aside from those which fire...

I'm using Excel 2010. I have all cells locked in a worksheet, and am using the following code. ActiveSheet.Protection.AllowEditRanges.Add Title:="dhRange", Range:=Rows("17:9000") ' Allow rows 17 to 9000 t0 be edited ActiveSheet.Protect Password:="ThisIsMyPassword"...

Morning everyone, I have a workbook that is going to be used by someone who has a (deserved) reputation for wrecking data. I am trying to restrict her access to the sheet, so she can enter but not ruin things. I have set it up so that the restrictions only apply to her network log-on (using...

Hi , I have an excel workbook with 12 worksheets. each worksheet is password protected. I know the password, after I unlock the sheets and save&close, when i open again the sheets are locked, I would like the sheets to be unlocked even after exit, can any one help me please Thanks in advance;

I am trying to protect an excel file. It contains data in hidden tabs that I do not want shared. I know that its fairly easy to unlock an excel file that has been protected with a few lines of code. I had an idea but needed help to know if it is possible to do it. Is there a piece of code that...

Hi, I need to create a Macro to protect a particular worksheet with a password in a workbook. For example:- my workbook has a filename "Vignesh.xlxs". i have many sheets in that such as "Jan", "Feb", "Mar", Apr", "May"..... "Dec". Here i need to protect only "Jan" to "Dec" sheets with same...

Good day, Excel people~! I've been given a little problem to investigate at my work; a colleague has a generic sheet that he wishes to post onto our company Sharepoint so that multiple people may open it and add whatever info is relevant to them. The problem is that these people have a tendency...

I have about 65 spreadsheets with many VBA modules. I password protected the VBA modules in each. I want to update and replace modules through code that opens each spreadsheet and deletes and/or adds a replacement module. Got that working, but need a way to enter the password to unprotect the...

Greetings, I am working on a fairly complex model with lots of formatting and lots of checkboxes. I need a quick way to get all the cells with a checkbox unlocked so when I protect the sheet they are usable. I have lots of merged cells so just highlighting a column is a non-starter. Any help...

Hi. I am using the worksheet open event as the trigger to copy and paste editable ranges from other worksheets into a 'summary sheet' but I do not want users to be able to edit the ranges in the resultant 'summary sheet'. I can get the data okay but the open event seems to be causing looping...

Hi, I've been making some changes to a workbook for a few days and I have just found that something I've done has caused the input page to be protected in some way. It's a page made up primarily o drop-down lists, and when I try to change a cell I get a message "this cell or sheet is protected...

Hi there, So I have some PDFs embedded into my excel spreadsheet and I want to protect my worksheet as there is a lot of sensitive information on there as well as the embedded PDFs, however in order for someone to open the PDF then it needs to be "unlocked" in the protection settings which...

Hi, I have a macro to spell check a protected workbook in excel 2010: Sub Spellcheck() ActiveSheet.Unprotect Password:="Project Delivery" Cells.CheckSpelling CustomDictionary:="CUSTOM.DIC", _ IgnoreUppercase:=False, AlwaysSuggest:=True, SpellLang:=2057 '2053 ActiveSheet.Protect...

Password protected VBA module causes Excel to crash on debugs. Macros work fine if I open VBE and enter my password. I'm using Range.("This range does not exist").Select to force a debug. If I run my macro without entering my module password, the debug window appears and Excel crashes. If I...

I need to protect some columns with formulas in an Excel Table. Is there any way I can do this without using a macro. The moment I convert my data to a table the protection feature goes off. How to avoid thishttp:

Hii, Gyus I am using following codes for current time and current date in sheets, Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column <> 2 And Target.Column <> 5 Then Exit Sub Application.EnableEvents = False Target.Offset(0, -1).Value = Date Target.Offset(0, 1).Value = Now -...

Hello, I am trying to protect the conditional formatting formulas, however I still need to be able to paste data into the cells so the normal method of protection won't work. Thanks in advance

Ladies and Gentlemen, I could really use your help here. I have recently been tasked with modifiying our existing Macros in Excel 2010. The Excel files open great without passwords or issues. I choose to navigate to the IDE by using ALT + F11, like everyone else. It opens the IDE and everything...

I have a large workbook, wherein I use UserInterfaceOnly on the sheets implemented through the Workbook_Activate event. Up until now it's always worked just fine, but now it doesn't work in a specific circumstance. When I open the file directly or with a shortcut or with the File->Open...

I am using excel 2007. Is there a way to ensure that when you send an excel spreadsheet to someone else that you can ensure that they cannot see any of your macros? The problem is that when I open an excel spreadsheet and goto my developer tab and then click on macros a whole list of macros...