Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi -
I have a workbook with about 15 separate sheets, for 15 PMs. Is there a way that I can give read-only access to the workbook with the EXCEPTION of the 1 sheet that belongs to a specific person? Any help would be greatly appreciated. |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Only with Excel 2003 or above.
Otherwise, it could be tough. Here's some code: http://vbaexpress.com/kb/getarticle.php?kb_id=33 And one idea on how to force the user to enable macros so your code above will work as it should: http://vbaexpress.com/kb/getarticle.php?kb_id=578 THIS IS NOT FOOLPROOF!! Use it only for low-level security. ************ Hope it helps! Anne Troy www.OfficeArticles.com "emcphee" wrote in message ... Hi - I have a workbook with about 15 separate sheets, for 15 PMs. Is there a way that I can give read-only access to the workbook with the EXCEPTION of the 1 sheet that belongs to a specific person? Any help would be greatly appreciated. |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Thanks Anne!
I do have Excel 2003, and I did set up password protection in each sheet. However, once the individual unlocks the sheet, it remains open unless they "re-lock" it. Is there a way that I can make the sheet automatically lock again once it's exited? Thanks in advance, Eunice "Anne Troy" wrote: Only with Excel 2003 or above. Otherwise, it could be tough. Here's some code: http://vbaexpress.com/kb/getarticle.php?kb_id=33 And one idea on how to force the user to enable macros so your code above will work as it should: http://vbaexpress.com/kb/getarticle.php?kb_id=578 THIS IS NOT FOOLPROOF!! Use it only for low-level security. ************ Hope it helps! Anne Troy www.OfficeArticles.com "emcphee" wrote in message ... Hi - I have a workbook with about 15 separate sheets, for 15 PMs. Is there a way that I can give read-only access to the workbook with the EXCEPTION of the 1 sheet that belongs to a specific person? Any help would be greatly appreciated. |
#4
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
You'll need VBA in your Worksheet_Activate (for all worksheets, I assume)
and on Close that checks if the sheets were protected and, if they weren't to protect them. You would really do much better in the Excel VBA newsgroup. ************ Hope it helps! Anne Troy www.OfficeArticles.com "emcphee" wrote in message ... Thanks Anne! I do have Excel 2003, and I did set up password protection in each sheet. However, once the individual unlocks the sheet, it remains open unless they "re-lock" it. Is there a way that I can make the sheet automatically lock again once it's exited? Thanks in advance, Eunice "Anne Troy" wrote: Only with Excel 2003 or above. Otherwise, it could be tough. Here's some code: http://vbaexpress.com/kb/getarticle.php?kb_id=33 And one idea on how to force the user to enable macros so your code above will work as it should: http://vbaexpress.com/kb/getarticle.php?kb_id=578 THIS IS NOT FOOLPROOF!! Use it only for low-level security. ************ Hope it helps! Anne Troy www.OfficeArticles.com "emcphee" wrote in message ... Hi - I have a workbook with about 15 separate sheets, for 15 PMs. Is there a way that I can give read-only access to the workbook with the EXCEPTION of the 1 sheet that belongs to a specific person? Any help would be greatly appreciated. |
#5
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Yes - that is very helpful. Many thanks!
"Anne Troy" wrote: You'll need VBA in your Worksheet_Activate (for all worksheets, I assume) and on Close that checks if the sheets were protected and, if they weren't to protect them. You would really do much better in the Excel VBA newsgroup. ************ Hope it helps! Anne Troy www.OfficeArticles.com "emcphee" wrote in message ... Thanks Anne! I do have Excel 2003, and I did set up password protection in each sheet. However, once the individual unlocks the sheet, it remains open unless they "re-lock" it. Is there a way that I can make the sheet automatically lock again once it's exited? Thanks in advance, Eunice "Anne Troy" wrote: Only with Excel 2003 or above. Otherwise, it could be tough. Here's some code: http://vbaexpress.com/kb/getarticle.php?kb_id=33 And one idea on how to force the user to enable macros so your code above will work as it should: http://vbaexpress.com/kb/getarticle.php?kb_id=578 THIS IS NOT FOOLPROOF!! Use it only for low-level security. ************ Hope it helps! Anne Troy www.OfficeArticles.com "emcphee" wrote in message ... Hi - I have a workbook with about 15 separate sheets, for 15 PMs. Is there a way that I can give read-only access to the workbook with the EXCEPTION of the 1 sheet that belongs to a specific person? Any help would be greatly appreciated. |
#6
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
You're welcome!
************ Hope it helps! Anne Troy www.OfficeArticles.com Check out: www.ExcelUserConference.com "emcphee" wrote in message ... Yes - that is very helpful. Many thanks! "Anne Troy" wrote: You'll need VBA in your Worksheet_Activate (for all worksheets, I assume) and on Close that checks if the sheets were protected and, if they weren't to protect them. You would really do much better in the Excel VBA newsgroup. ************ Hope it helps! Anne Troy www.OfficeArticles.com "emcphee" wrote in message ... Thanks Anne! I do have Excel 2003, and I did set up password protection in each sheet. However, once the individual unlocks the sheet, it remains open unless they "re-lock" it. Is there a way that I can make the sheet automatically lock again once it's exited? Thanks in advance, Eunice "Anne Troy" wrote: Only with Excel 2003 or above. Otherwise, it could be tough. Here's some code: http://vbaexpress.com/kb/getarticle.php?kb_id=33 And one idea on how to force the user to enable macros so your code above will work as it should: http://vbaexpress.com/kb/getarticle.php?kb_id=578 THIS IS NOT FOOLPROOF!! Use it only for low-level security. ************ Hope it helps! Anne Troy www.OfficeArticles.com "emcphee" wrote in message ... Hi - I have a workbook with about 15 separate sheets, for 15 PMs. Is there a way that I can give read-only access to the workbook with the EXCEPTION of the 1 sheet that belongs to a specific person? Any help would be greatly appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Read Only_Protected Workbook? | Excel Discussion (Misc queries) | |||
mailing one sheet from workbook | Excel Discussion (Misc queries) | |||
Use Sheet CodeNames to Select Sheet in Different Workbook | Excel Discussion (Misc queries) | |||
Does excel recognise names rather than cells? | Excel Worksheet Functions | |||
Network access to file - read only property | Excel Discussion (Misc queries) |