software

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.

Only with Excel 2003 or above.
Otherwise, it could be tough. Here's some code:
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:
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

quot;emcpheequot; gt; wrote in message
...
gt; Hi -
gt; I have a workbook with about 15 separate sheets, for 15 PMs. Is there a
gt; way
gt; that I can give read-only access to the workbook with the EXCEPTION of the
gt; 1
gt; sheet that belongs to a specific person?
gt;
gt; Any help would be greatly appreciated.
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
quot;re-lockquot; it. Is there a way that I can make the sheet automatically lock
again once it's exited?

Thanks in advance,

Eunice

quot;Anne Troyquot; wrote:

gt; Only with Excel 2003 or above.
gt; Otherwise, it could be tough. Here's some code:
gt; vbaexpress.com/kb/getarticle.php?kb_id=33
gt; And one idea on how to force the user to enable macros so your code above
gt; will work as it should:
gt; vbaexpress.com/kb/getarticle.php?kb_id=578
gt; THIS IS NOT FOOLPROOF!! Use it only for low-level security.
gt; ************
gt; Hope it helps!
gt; Anne Troy
gt; www.OfficeArticles.com
gt;
gt; quot;emcpheequot; gt; wrote in message
gt; ...
gt; gt; Hi -
gt; gt; I have a workbook with about 15 separate sheets, for 15 PMs. Is there a
gt; gt; way
gt; gt; that I can give read-only access to the workbook with the EXCEPTION of the
gt; gt; 1
gt; gt; sheet that belongs to a specific person?
gt; gt;
gt; gt; Any help would be greatly appreciated.
gt;
gt;
gt;

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

quot;emcpheequot; gt; wrote in message
...
gt; Thanks Anne!
gt;
gt; I do have Excel 2003, and I did set up password protection in each sheet.
gt; However, once the individual unlocks the sheet, it remains open unless
gt; they
gt; quot;re-lockquot; it. Is there a way that I can make the sheet automatically lock
gt; again once it's exited?
gt;
gt; Thanks in advance,
gt;
gt; Eunice
gt;
gt; quot;Anne Troyquot; wrote:
gt;
gt;gt; Only with Excel 2003 or above.
gt;gt; Otherwise, it could be tough. Here's some code:
gt;gt; vbaexpress.com/kb/getarticle.php?kb_id=33
gt;gt; And one idea on how to force the user to enable macros so your code above
gt;gt; will work as it should:
gt;gt; vbaexpress.com/kb/getarticle.php?kb_id=578
gt;gt; THIS IS NOT FOOLPROOF!! Use it only for low-level security.
gt;gt; ************
gt;gt; Hope it helps!
gt;gt; Anne Troy
gt;gt; www.OfficeArticles.com
gt;gt;
gt;gt; quot;emcpheequot; gt; wrote in message
gt;gt; ...
gt;gt; gt; Hi -
gt;gt; gt; I have a workbook with about 15 separate sheets, for 15 PMs. Is there a
gt;gt; gt; way
gt;gt; gt; that I can give read-only access to the workbook with the EXCEPTION of
gt;gt; gt; the
gt;gt; gt; 1
gt;gt; gt; sheet that belongs to a specific person?
gt;gt; gt;
gt;gt; gt; Any help would be greatly appreciated.
gt;gt;
gt;gt;
gt;gt;
Yes - that is very helpful. Many thanks!

quot;Anne Troyquot; wrote:

gt; You'll need VBA in your Worksheet_Activate (for all worksheets, I assume)
gt; and on Close that checks if the sheets were protected and, if they weren't
gt; to protect them. You would really do much better in the Excel VBA newsgroup.
gt; ************
gt; Hope it helps!
gt; Anne Troy
gt; www.OfficeArticles.com
gt;
gt; quot;emcpheequot; gt; wrote in message
gt; ...
gt; gt; Thanks Anne!
gt; gt;
gt; gt; I do have Excel 2003, and I did set up password protection in each sheet.
gt; gt; However, once the individual unlocks the sheet, it remains open unless
gt; gt; they
gt; gt; quot;re-lockquot; it. Is there a way that I can make the sheet automatically lock
gt; gt; again once it's exited?
gt; gt;
gt; gt; Thanks in advance,
gt; gt;
gt; gt; Eunice
gt; gt;
gt; gt; quot;Anne Troyquot; wrote:
gt; gt;
gt; gt;gt; Only with Excel 2003 or above.
gt; gt;gt; Otherwise, it could be tough. Here's some code:
gt; gt;gt; vbaexpress.com/kb/getarticle.php?kb_id=33
gt; gt;gt; And one idea on how to force the user to enable macros so your code above
gt; gt;gt; will work as it should:
gt; gt;gt; vbaexpress.com/kb/getarticle.php?kb_id=578
gt; gt;gt; THIS IS NOT FOOLPROOF!! Use it only for low-level security.
gt; gt;gt; ************
gt; gt;gt; Hope it helps!
gt; gt;gt; Anne Troy
gt; gt;gt; www.OfficeArticles.com
gt; gt;gt;
gt; gt;gt; quot;emcpheequot; gt; wrote in message
gt; gt;gt; ...
gt; gt;gt; gt; Hi -
gt; gt;gt; gt; I have a workbook with about 15 separate sheets, for 15 PMs. Is there a
gt; gt;gt; gt; way
gt; gt;gt; gt; that I can give read-only access to the workbook with the EXCEPTION of
gt; gt;gt; gt; the
gt; gt;gt; gt; 1
gt; gt;gt; gt; sheet that belongs to a specific person?
gt; gt;gt; gt;
gt; gt;gt; gt; Any help would be greatly appreciated.
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt;
gt;
gt;

You're welcome!

************
Hope it helps!
Anne Troy
www.OfficeArticles.com
Check out: www.ExcelUserConference.com

quot;emcpheequot; gt; wrote in message
...
gt; Yes - that is very helpful. Many thanks!
gt;
gt; quot;Anne Troyquot; wrote:
gt;
gt;gt; You'll need VBA in your Worksheet_Activate (for all worksheets, I assume)
gt;gt; and on Close that checks if the sheets were protected and, if they
gt;gt; weren't
gt;gt; to protect them. You would really do much better in the Excel VBA
gt;gt; newsgroup.
gt;gt; ************
gt;gt; Hope it helps!
gt;gt; Anne Troy
gt;gt; www.OfficeArticles.com
gt;gt;
gt;gt; quot;emcpheequot; gt; wrote in message
gt;gt; ...
gt;gt; gt; Thanks Anne!
gt;gt; gt;
gt;gt; gt; I do have Excel 2003, and I did set up password protection in each
gt;gt; gt; sheet.
gt;gt; gt; However, once the individual unlocks the sheet, it remains open unless
gt;gt; gt; they
gt;gt; gt; quot;re-lockquot; it. Is there a way that I can make the sheet automatically
gt;gt; gt; lock
gt;gt; gt; again once it's exited?
gt;gt; gt;
gt;gt; gt; Thanks in advance,
gt;gt; gt;
gt;gt; gt; Eunice
gt;gt; gt;
gt;gt; gt; quot;Anne Troyquot; wrote:
gt;gt; gt;
gt;gt; gt;gt; Only with Excel 2003 or above.
gt;gt; gt;gt; Otherwise, it could be tough. Here's some code:
gt;gt; gt;gt; vbaexpress.com/kb/getarticle.php?kb_id=33
gt;gt; gt;gt; And one idea on how to force the user to enable macros so your code
gt;gt; gt;gt; above
gt;gt; gt;gt; will work as it should:
gt;gt; gt;gt; vbaexpress.com/kb/getarticle.php?kb_id=578
gt;gt; gt;gt; THIS IS NOT FOOLPROOF!! Use it only for low-level security.
gt;gt; gt;gt; ************
gt;gt; gt;gt; Hope it helps!
gt;gt; gt;gt; Anne Troy
gt;gt; gt;gt; www.OfficeArticles.com
gt;gt; gt;gt;
gt;gt; gt;gt; quot;emcpheequot; gt; wrote in message
gt;gt; gt;gt; ...
gt;gt; gt;gt; gt; Hi -
gt;gt; gt;gt; gt; I have a workbook with about 15 separate sheets, for 15 PMs. Is
gt;gt; gt;gt; gt; there a
gt;gt; gt;gt; gt; way
gt;gt; gt;gt; gt; that I can give read-only access to the workbook with the EXCEPTION
gt;gt; gt;gt; gt; of
gt;gt; gt;gt; gt; the
gt;gt; gt;gt; gt; 1
gt;gt; gt;gt; gt; sheet that belongs to a specific person?
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt; Any help would be greatly appreciated.
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt;
gt;gt;
gt;gt;