View Single Post
 
Old 02-26-2025, 12:36 PM
Aengus345 Aengus345 is offline Windows 10 Office 97-2003
Novice
 
Join Date: Feb 2024
Posts: 8
Aengus345 is on a distinguished road
Default

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
was nowhere to be found that I know how how to access.

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.)
Reply With Quote