security permission

For my company, we have Excel pulling from our database to generate reports and it includes some sensitive information (Salary, PII). I want to make it so that when a person opens the shared Excel sheet they hit a button, it checks the username, and unhides sheet2 and sheet3, or only unhide...

Guys, On my work machine I was running XP and 2007 Excel. While we migrated to 2010 Excel and Windows 7 Enterprise I needed to use a few project plans. These contained a few macros and were password protected docs. I use Excel 2016 at home so just opened them on USB. Now when I try and open...

I am looking to protect my written program in mircosoft office excel 2013/365. I am allowing others to use my program for a given time frame, but I want to protect my interest in the program I have written. I want to allow a user to use my program for a limited time frame only. I already...

hi everyone, I'm creating a workbook, for all the manger in my company. they have to have access to their department's sheet + the summary sheet. So here is how I did. when closed the workbook automatically set the visibility of every sheet to xlVeryHidden. when open a user form is shown...

Situation: I have a spreadsheet for work with Salespeople and their A/R aging. I would like the salesperson to see the accounts pertaining to them and not others. This is needed as some salespeople are know to poach customers away from others. I don't want to filter the report and send...

Has anyone ever tried the Access Web App for Sharepoint 2013? It literally creates an instance of SQL Server 2012 so this new "hybrid" should give the actual Application some new never-before-seen features. Share your thoughts! Has anyone ever done a row-level security or used of views with...

Hi there, I'm using Excel 2010 and I'm using it to print to a small recipt printer, I'm doing this by only adjusting the scaling precent of the page under custom scaling in the printing preferences. I need to lock this so that the salesperson at the actual store won't be able to change this and...

I need some help on figuring out how to send an email through Excel without getting the Microsoft Security message that asks you to Allow the message to be sent. I do not need any third party tool to be installed. Please help. [ Sub Try_this() Dim OLF As Outlook.MAPIFolder, olMailItem As...

Hi All, I have created a macro that, in the end, saves the file using the following code: ActiveWorkbook.SaveAs Filename:=oneback & "\" & deptname & "_QT Report_" _ & reportdateQ & ".xlsx", FileFormat:=xlOpenXMLWorkbook, CreateBackup:=FalseThis code usually works for saving the file...