Security - Protecting Macro while generating workbook thru VB 6.0

K

K.S.Srinivasan

Hi & Good Day Buddies,

Am generating excel workbooks at runtime using Excel Objects & am including Macros to the workbooks generated at runtime. I need to protect those macros from being viewed by the end user.

I looked after ms excel help where i came accross a property viz., Protected which is read only... how do i go about now

Am using windows 2000 Prof, MS Office 2000, MS Visual Basic 6.0 + SP 5

Wish u all a very very happy & a prosperous Chineese New Year :)
Gonci Fachai if am not wrong.... ;)

Thanx & Warm Regards,
K.S.Srinivasan
Aadithya Infopark,
Chennai.
 
Top