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.