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