View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default Work Book Security

No.

You can do various things, such as hide your sheets and unhide them via
code (leaving a single splash sheet saying "You must enable macros").

But protection in XL is very weak. It's a matter of a minute or less to
remove all internal and VBA protection from a workbook, with the right
tools, so you can't force the user to do much of anything...


In article ,
"Brent" wrote:

Is there a way to force someone to enable Macro's before opening up an Excel
file? I'm currently on Office XP. Thanks