View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
TSW632 TSW632 is offline
external usenet poster
 
Posts: 14
Default Ensuring Macros Are Enabled

Have any of you successfuly used Chip Pearson's method for this? It is
located at http://www.cpearson.com/Excel/EnableMacros.aspx

In Excel 2003 with SP3. I have tried it most recently with a blank
file:

I name a worksheet "Introduction" and select "xlSheetVeryHidden" for
that sheet in the vba editor, paste the code in ThisWorkbook, replace
the password in the code.

I get a variety of errors when I save and re-open.

I am indeed a novice so if you have made this work yourself, I would
appreciate knowing what, if any, changes you had to make.

Thanks