How to block access for a certain group of users ?

[RomulusMilea]

Hello all,

I was wondering if it is possible to create a macro routine for a specific action: I have created an Excel file with some important calculation, I will send it to a group of users, but I want certain users (having known user names) to open the file and to receive kind of message saying "This file cannot be accessed by this user. Please contact your administrator". User will have to click on OK button and right away all cells to remain visible, but to become password protected, with hidden formulas and also impossible to be copied. Does anyone have any suggestions ? Thank you .

 

[tmischler]

could you - assuming your other users aren't going to try and crack your codes, just list the usernames, eg. Password protect the sheet with something like

dim password as string
username = inputbox "enter user name"

dim password as string

select case username

case joe, mark, pete (users with access)
password = [whatever the password for your workbook is]

etc, etc?

 

[SydneyGeek]

Excel's security is not much good, so the operating system is your best bet. You could put the workbook in a folder with restricted permissions. That way, you could deny some people access, give others read-only access, and give a select group read-write access. One advantage; any other files which need the same treatment can be dropped into the same folder.

Denis

 

[JoeS01]

to Sydney Geek

How would you do this controlled folder access, please - sounds good!

 

[SydneyGeek]

It's fairly standard Windows admin -- the place I work, they regularly set up folders with restricted access. Talk to the IT guys about your needs, and they should be able to help.

EDIT -- Just ran a quick search and found this:

http://www.microsoft.com/windowsxp/using/security/learnmore/accesscontrol.mspx
http://vb123.com/toolshed/04_docs/accessdb_op_security.htm

Note -- you must be using NTFS, not FAT32 file system, to use this feature. But that shouldn't be an issue in a corporate environment.

Denis

 

[JoeS01]

thanks , Denis

Many thanks Denis, for pointing me in the right direction, and for the link to a previous post