Porblem Emailing Exce templates

[chexcel]

I have created excel templates and am sending them out to the clients via email. When they receive them they have to enable contents and the auto_open macro stops with an error 91 variable not found on the following line

ActiveSheet.Unprotect Password:="test"

They need to send out these templates to their sales rep and will probably encounter the same problem

Would anyone have come across this previously

Thanks

Regards

Carmel

[tony h]

The error is actually "Obect variable not found" which, in this case, means that at this point there is no activesheet. So it maybe worth looking at moving the code to an event that occurs later. Maybe the sheet activate method.

error 91 OBJECT variable not found

ActiveSheet.Unprotect Password:="test"

[HaHoBe]

Hi, Carmel,

the Auto_Open-macros from the standard modules have been replaced by the Workbook_Open-event in ThisWorkbook from Excel97 on.

Maybe make sure that the ActiveSheet is a worksheet and is protected and then run the code like

Please Login or Register  to view this content.

I would work around that indicating the codename for the sheet and replace ActiveSheet with that name (i.e. Sheet1).

Depending on what needs to do done with the sheet I wonder why you need to protect a sheet and send it to somebody who can unprotect it and hand it out. I would prefer to protect the sheet with the volatile setting of using UserInterfaceOnly:=True allowing macros to work on the sheet but not manual entries.

Ciao,
Holger

[chexcel]

Thanks Tony that helped

[chexcel]

Thanks Holger

I had not realised that the Auto open had been replaced that will be very useful to know in the future

Carmel

[HaHoBe]

Hi, chexcel,

do you mind changing the thread to Solved via Thread Tools above the first post if the issue has been resolved?

Ciao,
Holger