security

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

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

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

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

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

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

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

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,

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

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 I hope you can help I'm looking to introduce a front page to a worksheet which users must agree (tick box or click button) to the T&C's before they can look at subsequent sheets. I know how to add buttons etc but not sure how to add the security feature. Any help would be gratefully...

Greetings. I created macros in Excel 2003, but those macros now always trigger a security warning when I open the spreadsheet with a macro. Until recently, I could eliminate the security warning by creating my own digital certificate and then digitally signing the macro. That no longer works...

I've been searching and trying all day and still can't get this to work. I have a network folder structure I've setup automatically via VBA to support a project. I need to now set the permissions and want to use VBA as well so that all of this is repeatable. I can use icacls in VBA to...

Hi there. I have an add-in I've been working on. There is a part of it that goes out to the internet and grabs data from a table. Since it is an add-in, if the user has really high security, they will get a security warning popup every time they open any workbook. What I'd like to do is NOT...

Hi all Im having an issue when opening a file through a vba routine, when i open it manually (file open) it opens fine with no error messages other than the "automatic update of links has been disabled" which appears in the ribbon. When i open it using "workbooks.open", I eventually get a...

<tbody> GR# Name Head Amount 12 Usman Security 25000 12 Usman Admission 25000 12 Usman Tution Fee Aug 17000 13 Ali Security 25000 13 Ali Admission 25000 13 Ali Tution Fee Aug 17000 14 Omar Tution Fee 17000 </tbody> <tbody> GR # Name Security Admission Aug Sep 12 Usman 25000...

Hi, I am new to powerpivots. I have an Excel report with Data Model that I am looking to distribute to different Zone owners. There are 7 Zones, and the source data has all of them. How do I limit the report that I distribute only to one Zone since I do not want other Zone owners to see other...

Hello, I have a protected workbook that contains a hidden and protected sheet. I want to restrict all access to this sheet for the user of the spreadsheet. The problem I am running into is this: the user can simply link to the cells in the hidden sheet from a different workbook. This...

Hello, I have a spreadsheet that is shared with people throughout the company, but what they can see and do with the spreadsheet is limited I have password protection on the VBA Project, the workbook, and all the sheets. I allow the users to interact with the spreadsheet through macros. When...

Hi, I set password through File--->Protect work book-->Encrypt with password option like 1234 Through File--->Protect work book-->Protect work sheet option like ABCD. I shared my file to colleagues and disclosed password 1234 to open . They are able to change the password /...