Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Limit access to certain worksheets (tabs)
Hi,
I have a excel file with 16 spreadsheets and I would like to limit access of certain users to certain spreadsheets in the file. Is there any solution to this? Any help is much appreciated. Thanks & Regards |
#2
|
|||
|
|||
There's a solution to every problem!
If I was to accomplish something like this I would go about it in the following way. 1. Write some code that hides all the worksheets when the workbook opens. 2. Create a login dialog, and have the users login when the workbook opens. 3. Depending on which user logs in, unhide the sheets that they are entitled to use. That's of course just an outline of how to do it, much of the work you will need to do will come from programming in VBA, something that every Excel developer must be able to do. If you need more specific help re-post here, or contact me through my site. Regards Neil www.nwarwick.co.uk "bayhe" wrote: Hi, I have a excel file with 16 spreadsheets and I would like to limit access of certain users to certain spreadsheets in the file. Is there any solution to this? Any help is much appreciated. Thanks & Regards |
#3
|
|||
|
|||
Neil gave you a overview of one way to do this. But if you must keep the data
private/secure from the other users, then excel isn't the tool to use. With just a little bit of work, the protection can be broken and your data will be available. bayhe wrote: Hi, I have a excel file with 16 spreadsheets and I would like to limit access of certain users to certain spreadsheets in the file. Is there any solution to this? Any help is much appreciated. Thanks & Regards -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is there a limit to the number of worksheets in an excel file? | Excel Discussion (Misc queries) | |||
Using input to access different worksheets | Excel Worksheet Functions | |||
Opening worksheets in seperate excel tabs | Excel Worksheet Functions | |||
HELP! How do you--> Lock a set of rows but also link worksheets to | Excel Discussion (Misc queries) |