prevent

hi all... i have macro code to prevent delete in a cell.. this code : Private Sub Worksheet_Change(ByVal Target As Range) On Error GoTo Whoa Application.EnableEvents = False If Not Intersect(Target, Range("A2:A5,B2:B5")) Is Nothing Then If Len(Trim(Target.Value)) = 0 Then...

Is it possible using an Excel add-in to force all new spreadsheets to only be visible or functional if opened on a company computer containing the company add-in? I am looking for a security method that would prevent company documents from being able to be run or used on a computer outside the...

Hi, Is it possible to prevent manual entry in a selected column and use the same column for bar code scanning?

Hi. Im quite new to vba excel. Is there a way for me to prevent duplicate from being imported using any code or method. Below is the code that i will be using. ChDir "Open from directory sales = Application.GetOpenFilename("Text Files (*.txt), *.txt") Workbooks.OpenText...

Is there a way to add protection to a sheet that already has certain restrictions for normal users, to prevent them from changing the font and size of all cells in the workbook? thanks for any help

Using VBA code, 1. Is it possible to block deleting, say Row 10 and Column P (but the other rows and columns should be deletable)? 2. If a sheet contains a value 'Do not delete", then the row and column of the cell should not be deletable? That is, the code should pick up the column address...

Hi All How can I prevent users from entering duplicate data in a userform. I have tried the data validation but this only seems to work if you type in the cell an not when the data is passed from the userform. I have the following code for the form , row 5 "seal" is the column that cannot have...

I am using a simple formula such as this: =COUNTA(Sheet1!D2:D20) The problem is that anytime a row is deleted from 1 to 20, the formula adjusts itself. How do I prevent this from happening? I have been tinkering with the INDIRECT function but have had no luck making it work. Thanks!

I have a excel workbook where multiple people work in (not shared). But I want to prevent that people create data and then dont save. I can make a macro for them to automatically save every change they do. But when people work in a read only version (because someone else has the file open) they...

Good morning mr excel community I have made a userform which I was hoping to keep open trough the day in the memory , but when I click out of excel and start browsing , when I come back to excel and try to do something with the userform I get error with the worksheet like this: Dim ws As...

Hi All, I have a form on excel which is being used on a trial basis. Once the trial is up a message box appears to inform the user their trial has expired. If the expiry date in the code is 31/08/17 it should expire as today's date is 15/09/17...which it does. But I've realized if I manually...

I have office 2016 64 bit which freezes regularly Can anyone advise on how to prevent this from happening ?

After ive have been linking over 100 cells between 2 different excel files, all of a sudden, my links all went #REF! and I have to start over :( =VLOOKUP(D459;'[1. Speedo Cases GEM 170728.xlsx]speedo'!$B$10:$FZ$115;3;FALSE) became =VLOOKUP(D483;#REF!;3;FALSE) Any one has an idea how this...

Hope this makes sense. I have a co-authored spreadsheet that we're having save issues with. When one user is working all is fine, but when we get multiple users there are "Unable to Save" errors. The spreadsheet has custom views set up for each user (that hide columns), as well as custom...

It is possible to prevent users from seeing the VBA by adding a password (admittedly though it can be easily cracked). However, is it possible to prevent users from opening the VB Editor at all? The reason is my program has events but supposing for argument sake, the user opens the VB Editor...

I have an excel form that has certain required fields (more than one) which must have data entered into them. I have created a button that emails the form to me using a VBA statement. Is there a way to prevent the form from being submitted if any of the required cells are left blank? Any...

Hi, I can't seem to get my code to pick up a Worksheet_Change event for when a cells has a formula. This is what I have so far (the top part is to prevent pasting of formulas, I have highlighted the relevant code in red). Private Sub Worksheet_Change(ByVal Target As Excel.Range) Dim Rng As...

Hello, Is there an effective way to prevent a user from changing the file extension of a file? For example, if a file needs to remain .xls I want to prevent a user from changing it to .xlsx, etc. I assume I would need to add code to the Workbook_BeforeSave event? Or is there a better way...

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...

Hi all, I'm using Excel 2007, and I want to prevent users from un-ticking the shared workbook box. My searches so far come up with 2 solutions, which do not work for me: 1) Use "Protect & Share workbook" with a password. But this is unsuitable because it appears you can only protect the...