Thanks, Jim - I really appreciate the help.

"Jim Cone" wrote:


Worksheets("Sheet17").Unprotect "led52not"
With Worksheets("Sheet17") .Shapes("Text Box 2").TextFrame.Characters
.Text = "P"
.Font.Name = "Wingdings 2"
End With
--
Jim Cone
Portland, Oregon USA
http://www.contextures.com/excel-sort-addin.html





"golf4"
wrote in message
Hi, Everyone -
I've run into this issue, and I can seem to figure it out. In my
spreadsheet, I've included several text boxes at the bottom of the
pages. The VB code I also have included is, when the pages are
printed, alternately place a "P" in the text boxes. Then I formatted
the text boxes to use WingDings II so that checkmarks SHOULD appear in
the boxes. I've also included code that would (1) unprotect the sheet;
(2) print the pages with the text boxes; and (3) reprotect the sheet.
What keeps on happening is that, for some unknown reason (at least to
me), the font in the text boxes keeps returning to Calibri before
printing so all that shows in the boxes are "P"s. I would then go in,
unprotect the sheet, change the font in the boxes and resave the
workbook. The same thing will happen. What I'm wondering is whether
there is a way I could modify my code so that the font setting, in the
text boxes, would keep at WingDing II and not change? THANKS FOR THE
CONTINUED HELP!!! Frank

I've attached my code below:
-snip-
.