permissions

  1. B

    VBA List File Info

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

    Cause/fix for extra .TMP files generated

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

    Workbook on Public Server - can sheets be locked out to individual users??

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

    Return Directory Permissions

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

    Setting complex permissions for linked workbooks

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

    How can i see the attachments

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

    macro workbook other users

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

    Test Access to Controlled Folder

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

    User permissions in a single sheet???

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

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top