Textbox & Save file problem
 

I have a textbox from the Drawing toolbar on a sheet.
The textbox is "enabled" and user enters their data.
They then click Save or SaveAs.

Code in the Workbook_BeforeSave Event then operates.

This is the 'Save' sequence:

'save the new fax, and leave it open
Application.EnableEvents = False
Activesheet.Protect Password:="abc"
ActiveWorkbook.Protect Password:="abc"
ActiveWorkbook.SaveAs fName
Application.EnableEvents = True

Problem. When I open the saved copy, the textbox
contents are missing. How do I "burn" the textbox's
contents into the sheet before the Save, please?

Regards.


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.727 / Virus Database: 482 - Release Date: 26/07/2004