protection

Hi ALl Hoping someone will be able to help me out there, I've been racking my brains and cannot find a solution. Please see code below. The intention is to apply protection to the sheet whilst allowing ActiveX functionality (i.e. use of slider bars) whilst the worksheet is protected. It had...

Hi all, I'm trying to lock down a spreadsheet so that users can change a Pivotchart using slicers, but not in any other way as I need data rounding as a calculated field. I can do this, but only by locking the Pivotchart, which means the user can't select it. This is a problem because I want...

I had an application in 2010 which was working fine. I recently have to migrate my application to 2013. There was lot of flickering occurred in 2013. So I have used application.screenupdating = false in beginning of my macro and set it back to TRUE during end of my macro. Though setting of...

Hello All, I have a tricky situation. I hope there is a solution for it. Otherwise I will have to rework my workbook. I have a worksheet that has public information in columns A through R. It has confidential information in columns S through AD. I need to share this spreadsheet on a...

I am making an excel sheet, I want to ensure that no one can change data once the data is entered. for that I used following code Private Sub Worksheet_Change(ByVal Target As Range) ActiveSheet.Unprotect ("newpass4") Target.Locked = True ActiveSheet.Protect ("newpass4") End Sub however...

I'm nearly finished a workbook and I'm having issues with the macro. The workbook's main function is to allow our general staff to enter information into an input sheet and then have that information populate our worklog table. The table and the workbook are protected outside of a few cells...

I am creating a program within Excel where the workbook will be used by multiple players. Each player will be on their own sheet within the Workbook itself. Each sheet references answers selected in others sheets. Part of the program prompts users to select an answer from a drop down menu, so...

This one has me perplexed. In Excel 2010 or 2013 1. Choose a cell and uncheck the "Locked" property 2. Protect the worksheet (the selection of the "allow" checkboxes seems irrelevant) You will notice that the "Accounting Number Format" dropdown on the ribbon, when clicked, has no selectable...

Hi all, Need some help please. The macro I have created currently creates a new sheet from a current one (copies it exactly and then changes a few things in the sheet as per what I have asked it to do). The macro is currently working fine and does what I want it to do, however I've noticed...

Hello everyone, I was wondering if you could help me with something that would be truly invaluable to my work life! I already have the first 2 pieces of the puzzle, however, my knowledge doesn't allow me to complete the solution. 1. I already have a macro that lists all of the workbooks...

I have an excel file which imports data from a text file and then generates a report based on the data. I would like to have a way to limit the number of times a user can access this report, so I can charge for usage. Ideally, i could set the number of times they can run this file (or import...

Hello, I've been working on 2 workbooks, one "Master.xlsm" is for inputting of information (Workbook Protected) the other "Viewer.xlsm" is for displaying it in a similar to read-only format (Sheet Protected Only). The main information which is shared between the two is the background color of...

I have retested and the workbook shows all 4 worksheets (individually) password protected, but on e-mailing the protection is not present. I tested with the above action PLUS "Protect workbook" and that seems to hold the protection for 1 page that's visible but is still not working correctly...

Hi, How secure is Excel's sheet protection? Is there a better way to go about it? I need to hide formulas. Thanks!

What is the best way to send a file with a macro? I want to make sure a protect the recipient as much as possible because i know macros can be destructive. <o:p></o:p>

How can the top row of a worksheet be protected/locked? We have a status log being accessed by multiple people who need to be able to add/delete rows. People keep putting typos in the top row however, which contains our column titles - so I want to find a way to lock that down. I have tried the...

Hi all, I have an Access 2010 database that is on a shared drive so many people use it, and i want to password protect it so only those with a password can get into the actual file (in case we need to make updates to it.) I'm able to put password protection on the file, but the problem is that...

Hi all. Is there a way to prevent users from password protecting a workbook? A colleague of mine has several workbooks that he updates using a seperate workbook and VBA, however, depsite being told not to, some of the owners of the workbooks he updates keep password protecting them which...

I have a form which people will use to enter data in a standardized way. The table has columns A:C as formulae and columns D:G as empty cells ready for people to add the necessary data using a mix of Data Validated pick lists or free-form text. I've locked columns A:C to prevent people...

I created a workbook that will be distributed and used by hundreds of people within my organization. The workbook contains macro's and sheets that I have protected within Excel itself, using passwords on sheet level, workbook level and VBA level. I don't want the users to get acces to the...