View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
kalz kalz is offline
external usenet poster
 
Posts: 7
Default workbook dont run macro under a lower version

Dear All,

Pls help tt,I have create a workbook with lox macro, and hav to hide them
from the end users, it was saved as "Microsoft Excel wookbook" type,(i.e. as
restricted from saving as a lower version workbook. However, problem is when
i try to open it under a lower version of MS-Office 2000, it promps me a run
time error msg and asking for debugging. The bugging line indicates a copy
and paste special section not able to run. On the other hand, if i choose to
End the debug, certainly no macro proceeded. If there any way to solve the
problem? or even, not to hide the macro but only the pre-definied password
inside macro ?

thx soso much!!