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
|
|||
|
|||
I might suggest a short macro that unhides various worksheets based on
the user entering a specific password in a textbox or possibly even a worksheet cell. If you'd like more assistance, email me at and I'll send you a typical spreadsheet. Regards - Fred 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
|
|||
|
|||
I might suggest a short macro that unhides various worksheets based on
the user entering a specific password in a textbox or possibly even a worksheet cell. If you'd like more assistance, email me at and I'll send you a typical spreadsheet. Regards - Fred 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 |
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) |