Excel 2007 security on sheets for shared workbooks

J

jayjavina

New Member
Joined
Feb 3, 2009
Messages
34
Hi,

is it possible to set some security in a specific sheet where in only a specific user can open since the workbook shared with different users?

Ex. SHEET1 can only be opened by Mr.B and SHEET2 can only be opened by Mr.C.

Thanks! :biggrin:
 

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)
You must log in or register to reply here.

Similar threads

I
  • Question
macros blocked but all security settings appear to be correct
Replies
2
Views
128
IMPOSSIBLE7925
I
P
  • Solved
Macro on server based workbook runs fine for me & colleague, but run-time errors for another colleague
Replies
7
Views
445
PerseveringHarold
P
I
  • Question
VBA - Copy Sheet from a workbook saved as a date - paste to specifically named sheet in another workbook based on the date
Replies
2
Views
186
Insurance Dave
I
R
  • Solved
Worksheet CodeName as type Worksheet
Replies
7
Views
109
StephenCrump
S
F
  • Solved
Excel Workbook Licensing/Security System
Replies
7
Views
392
Falko26
F

Forum statistics

Threads
1,214,391
Messages
6,119,239
Members
448,879
Latest member
VanGirl

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top