About Us

golf4[_3_]

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

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Maintaining text data format in a pivot table	Eric	Excel Discussion (Misc queries)	0	September 21st 09 07:33 PM
maintaining text rotation sending sheet to email recipient	RayK	Excel Worksheet Functions	0	January 13th 09 09:01 PM
Maintaining Text Formatting in a Lookup	loscherland	Excel Discussion (Misc queries)	2	April 21st 06 04:26 PM
setting ComboBox Control font	ts1	Excel Programming	0	September 22nd 05 06:35 PM
Setting the X axis scale/font	CLR	Charts and Charting in Excel	2	February 13th 05 08:32 PM

Menu

About Us