View Single Post
  #4   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. In order for code to run to determine whether macros are enabled,
macros have to be enabled...

Note that your current scheme wouldn't prevent anyone from setting the
date back on their machine, and opening a copy of the file.

In article ,
"Brent" wrote:

Thanks for the info. I have some code written that looks at the date and
if it is greater than a value I put in it then it deletes the sheet and
saves file. I'm really new at the VB side. Is there some code that looks
wether Macro's are Enabled? Again thanks for the help.