SELECTIVE ACCESS/ VIEWS OF WORKSHEETS

[MarkBeck]

Hi

I have a workbook that summarizes data via a detail sheet. The detail sheet is populated using several input ranges located on other sheets in the same workbook. I need to restrict access to most worksheet to most people.

What is the easiest way to achieve this?

Mark

 

[firefytr]

Depends on how much you want to "restrict access". If you're talking just restrict changing of data, you have worksheet protection and, in 2003 and up, range protection. If you're talking about restricting in terms of 'viewing', then you're going to find there is no native method for this, however, with a detailed VBA method, this can be done (it is extensive).

Regards,
Zack Barresse

Simplicity is the ultimate sophistication. What is a MS MVP? PODA
- Leonardo da Vinci

 

[MarkBeck]

Can such a VBA code assign different passwords to access the sheet and different viewing rights?

If i split the source/ summary data in two-plus workbooks, will they update when not both are open?

 

[firefytr]

If you choose to set Update External Links from the Tools | Options menu, they will update on open, also if you do a full recalc/dependency rebuild (Ctrl + Shift + Alt + F9). As for different viewing rights of the same sheet, there's no real good avenue for that.

One alternative might be to have one data sheet that is filtered whereas users cannot change the filter (protected sheet) but is filtered to view only their data on an applied filter via VBA. What were talking about here could mean changing your entire data structure and adding a LOT of VBA code. This could mean a lot of work.

Regards,
Zack Barresse

Simplicity is the ultimate sophistication. What is a MS MVP? PODA
- Leonardo da Vinci

 

[MarkBeck]

I Thank you.

Mark