security

  1. D

    Permantely Disable the prompt SECURITY WARMING: Autmoatic update of links has been disabled. FOR ALL WORKBOOKS

    Hello Everyone, Is everyone having as much fun with Microsoft Excel 365? It's terrible, honestly I don't understand what Microsofit is doing. Its' the worst Excel, not too mention the new the entire operating system is garbage. I feel like they regressed a decade. I hate it so much. Anyway...
  2. D

    efficient way to lookup and return multiple values?

    currently i i want to look up a unique security ID to another tab and return the inventories its in. the problem with obviously vlookup is that it would only return the first inventor result found.....what would be a way to return all the inventories the security ID is in? i suppose this can't...
  3. D

    How to Simplify this Time Consuming Tax Via Macro

    Here's the link to a sample spreadsheet I made: https://drive.google.com/open?id=1cQJvncI9xsAsrTicUA4Ql-MnZI2pwW_d Essentially, I want the macro to go to the "Final" tab -filter for each unique security ID -insert a new sheet and name it that security ID -and copy and paste that info into...
  4. S

    Crashed/Recovered excel ... enable macros greys out everything!

    Desperate: My excel crashed. I rebooted, and downloaded a backup copy of it. Now when i open it, it says: "SECURITY WARNING some active content has been disabled. Click for more details." I instead Enable Content, and when it does so, most features are grayed out, including saving it and even...
  5. J

    Locking cells

    Hi, I have a spreadsheet with some formulas in to represent a receipt. I want to be able to lock the cells with formulas. I think this is easy enough. My trouble is I want to lock some cells to accounting GBP currency. basically so a figure can be entered but so that somebody cannot delete...
  6. T

    Restricting use of a file

    I have a report that I generate weekly. Our users (about 15 or 16) go into the report and add accounting details. Over the last few months, data has been damaged by users dragging their data down and sometimes over the data entered by other users. I would like to create an AutoOpen macro that...
  7. C

    Macro disbled

    Hi, Trying to enable macros to run on excel binary sheet. I have changed the trust centre settings to enable all macros but still get the security warning and unable to run any macros ? Thanks in advance
  8. B

    Need help opening excel file from access form button

    Hi Everyone, I am looking for a BETTER way to open an Excel file from a button in a Form. I have tried using a hyperlink which works however I get the "A potential security concern has been identified". What I am looking for is either code or a method to get rid of the "Security Concern"...
  9. G

    Excel Security

    I have a spreadsheet that has confidential information. I know how to lock the sheet and hide the confidential info that is not the problem, What I want to know is there a way to have two levels of security. Two different passwords to open more or less. Some people need to see the confidential...
  10. J

    Need a formula that can calculate employers cost on employees payroll with the following.

    Employee wages = x Social security tax rate = 6.2% Social security limit = $128,700(no tax payed after) FUTA tax rate = .6% FUTA limit = $7,000 Medicare tax rate = 1.45% No limit
  11. M

    Native DB Query Prompt - when sharing workbook

    Hi There I have a workbook which uses Power Query. I have tried the various suggestions I have found online for disabling the Native DB Query security prompts which seem to work when I refresh the workbook on my machine. However when the workbook is shared with other users it seems to ignore...
  12. C

    Power Query Security Settings

    Hi All, I am having a difficult time finding guidance on the right settings for Excel 2016 so that I can use Power Query. Most of the files I use are from my own desktop but I continue to receive this error message (Yellow Banner once I initiate the Power Query add in). "To help protect your...
  13. K

    Formatting cells for social security #'s

    Hello - I'm trying to create a column(F) in which the user would need to enter their 9 digit social security number without dashes. Therefore if they enter a dash, or don't enter the full 9 digits they should be prompted to do so with a pop up. I tried data validation and entered the...
  14. V

    Check and Capture first date not in order

    Hello, Have a column representing dates in order of months a security is in a portfolio. Some months the security is not in the portfolio. Would like a formula to capture the first month the security comes back in the portfolio after a break. Eg listed below the security is absent between Jan...
  15. M

    Moving multiple sets of columns to new tabs via VBA

    Hello, We get an excel data sheet sent to us weekly that has security information all on one excel worksheet - each security has two columns (ie - A:B, C:D, E:F, etc etc), and we need to copy each security to its own worksheet and save that sheet as a text file for my company to import this...
  16. R

    Workbook Security

    I have a workbook that I only want certain users to be able to open. I have a list of network usernames that should have access on a worksheet called "LISTS". The list of usernames is in column "M" (range M2:M159) that has a dataname of "usernames". How do I set up some VBA code to look at...
  17. Nelson78

    Navigatine IE with VBA: a security alert, how to answer yes

    Hello everybody. I'm navigating IE with vba. Now, I need to answer "yes" to the following alert, as I do in manual navigation, to enter the intranet: https://imgur.com/a/J9SSbyI Consider: 1) the alert is exactly what you see in the image, but Current site and Intranet site are different (I...
  18. H

    Security - AddIn vs VBA Macro enabled file

    Hi, I see that there are numerous free programs that can remove VBA module passwords. I want to distribute a solution we have developed to a client, but as an Add-In, and want to know how the security differs between the Add-In and a normal macro enabled file (with the VBA code password...
  19. K

    Excel Spreadsheet security

    Good day, Is there a way to set up a security on a spreadsheet to be sold to multiple persons to prevent it being resold to those who did not pay.? I was thinking a unique security feature for each spreadsheet purchased. Thanks,
  20. J

    A potential security concern has been identified

    I cannot open access. The following message appears: A potential security concern has been identified. Warning: It is not possible to determine that this content came from a trustworthy source. You should leave this content disabled unless the content provides critical functionality and you...

Some videos you may like

This Week's Hot Topics

Top