![]() |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#5
|
|||
|
|||
I'm stumped. Unlike you guys, I'm a real newbie at this no matter how long I've been modifying vba in Word (I'm just no developer, just a simple power user.)So perhaps easiest would be to just outline the steps I've done. I changed the .WIZ extension to .DOC (as an online recommendation to change it to template .DOT just created a mess). (And the "If you don't change anything (just click Next, Finish on the UserForm" to me just meant that if I opened via NEW template, created same issue as changing .WIZ to .DOT, an open Word file that created error message after.) So I went with .DOC. Opened the .DOC with the .WIZ macros within. Then opened the VBE. I found the full line stated above: Code:
objActiveRange.Style = rgstrDaysStyle(iCalendarStyle) & iOrientation & iNoPicture But after that, I got nowhere ![]() I found that objActiveRange.Style line above okay, but the next one: Code:
objActiveRange.Style = "Boxes 11" - font.Size = 36, paragraph alignment= Center What am I doing wrong, please? Thank you! (p.s., 2nd option to just select the cells and do that ... ugh ... what's the point of vba if one can't do it all in one go??!! lol Besides, I started, but when you have 12 calendars to change font and alignment ... again, ugh lol. Thanks, though! Good in a pinch and if it were only one here and there, would do so. But I create themed yearly calendars periodically. Too much additional work. I don't have that kind of time.)
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Cell size changes when editing/font of column of record numbers suddenly changed colour | Johnrh | Excel | 1 | 05-21-2023 07:12 PM |
Modifying footnote numbers
|
Darko_Giac | Word | 2 | 03-16-2017 04:06 PM |
Need help with modifying a replacing font VBA code- similar task but subtle change
|
kissingfrogs2003 | Word VBA | 3 | 08-30-2016 11:42 AM |
Cell font and font size
|
teza2k06 | Excel | 3 | 02-10-2014 11:09 PM |
| Change font size of tasks in pane under Calendar | ghumdinger | Outlook | 2 | 08-16-2011 06:29 PM |