permissions

I have created a spreadsheet in which all the non-data-entry-cells have been locked and subsequently protected with the 'Protect Sheet' and 'Protect Workbook' buttons. So far, so good. However, I want to enable specific users to be allowed to edit a specific area without unlocking the entire...

Hi all! I want to create a protection to a workfile that will depend on the user ID, something similar to rights management, but i want to lock some cells and just let some cells to be edited. but this is an organization file, and there are some confidential information that depends on the...

I have little experience with SharePoint and just recently set up a SharePoint library folder. I need to set the user permissions for the folder such that users can download Excel workbooks from the folder, edit / modify the spreadsheets as they see fit, and store them to their personal...

Help please, I am looking for a VBA code that will list files in a directory/subdirectory (entire tree) for each file under each subdirectory. For each file I want to know the following: *File Name *File Size *File Type *Date Created *Date Last Accessed *Date Modified *Permissions (List each...

I have a problem where several users since they upgraded from Windows Vista with Excel 2007 to Windows 7 with Excel 2007 now get 2 temporary (.TMP) files generated each time after modifying an Excel document (.xlsx) and they DON'T GO AWAY! As an example. You have test.xlsx saved on 10-29-11...

Hi I have a workbook with multiple sheets that I intend to put on a public server at work. However, I only want certain sheets to be accessible to certain users. Obviously, the ones I want no-one to see can be hidden, but of those remaining, I want some people to have write access on some of...

I am looking to build a macro to inform a user via a custom ribbon label or other similar process whether or not they have write permission to a network directory. This directory has only two secuity permissions: write access or no access or view. This spreadsheet is used to export transactions...

Hello :) I have a few questions, I'm hoping someone can help. I have two workbooks, one (the master workbook) contains a several databases, the other (general workbook) contains worksheets designed to look up information in and add information to the databases using macros. Data is copied...

Hello, I have some questions while get started on excel, i wanted to first check if someone has posted, and i see that i am not able to open the attachments posted in the answers. I have logged in right. Please someone can help me, i see that there are some nice answers already in the old...

Hello. I have a workbook (not Personal.xls) that contains my macros, called My_Macros.xls and another workbook with data, let's say its called Data.xls. When I am logged on, I open both workbooks, and from Data.xls I run the macro stored in My_Macros.xls and it works fine. These files are stored...

I have a VBA module for which the ultimate goal is to write an Excel file into a specific folder. That folder resides on a networked shared drive and has controlled access via the user's LAN ID. So that the file is not lost in the event that a user is not authorized to read or write to the...

Hello again people! I'd like to know if there is a way to lock specific columns in a single sheet that are enabled with some kind of user permissions (password or sth like that..). I'd also like to know if this is possible for both read only, as well as completely hidding the columns that the...