Textbox & Save file problem

S

Stuart

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.
 
Top