Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old September 9th 05, 04:39 PM
fourskunks
 
Posts: n/a
Default multiple pages for multiple users

Before creating the workbook.

I want to set up a workbook with multiple worksheets. I want each of the
worksheets to have its own password to allow the assigned user to only access
to that sheet.

I still want in place a passcode for me to protect what I want to protect.

Does this make any sence?
Can it be done like in the scenario?
Or is it too complex?

It is going to be one workbook -- 19 worksheets (two hidden, one view only
and 16 individual users?

Any other suggestions will be appreciated?

fourskunks

  #2   Report Post  
Old September 9th 05, 07:29 PM
Dave Peterson
 
Posts: n/a
Default

Excel isn't made for this kind of security. If the data is not supposed to be
seen by the other users, don't share it in excel. Worksheet and workbook
protection (via tools|protection) is very easily broken.



fourskunks wrote:

Before creating the workbook.

I want to set up a workbook with multiple worksheets. I want each of the
worksheets to have its own password to allow the assigned user to only access
to that sheet.

I still want in place a passcode for me to protect what I want to protect.

Does this make any sence?
Can it be done like in the scenario?
Or is it too complex?

It is going to be one workbook -- 19 worksheets (two hidden, one view only
and 16 individual users?

Any other suggestions will be appreciated?

fourskunks


--

Dave Peterson


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
sharing a workbook and incorporating changes from multiple users mprible Excel Worksheet Functions 0 July 27th 05 07:34 PM
How to allow multiple users to update workbook (on network)? quddusaliquddus Excel Discussion (Misc queries) 0 June 29th 05 07:33 PM
Excel workbook to be used by multiple users at same time....possible??? malik641 Excel Worksheet Functions 1 June 26th 05 01:45 AM
Single worksheet, multiple pages? Peter Excel Discussion (Misc queries) 9 January 23rd 05 09:51 PM
combining multiple pages from Web automatically Terri and Rob Excel Discussion (Misc queries) 1 December 5th 04 11:09 PM


All times are GMT +1. The time now is 11:59 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017