Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #5  
Old 02-26-2025, 12:36 PM
Aengus345 Aengus345 is offline Modifying calendar.wiz for cell alignment and font size of the day numbers in calendars? Windows 10 Modifying calendar.wiz for cell alignment and font size of the day numbers in calendars? Office 97-2003
Novice
Modifying calendar.wiz for cell alignment and font size of the day numbers in calendars?
 
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
 



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 calendar.wiz for cell alignment and font size of the day numbers in calendars? Modifying footnote numbers Darko_Giac Word 2 03-16-2017 04:06 PM
Modifying calendar.wiz for cell alignment and font size of the day numbers in calendars? Need help with modifying a replacing font VBA code- similar task but subtle change kissingfrogs2003 Word VBA 3 08-30-2016 11:42 AM
Modifying calendar.wiz for cell alignment and font size of the day numbers in calendars? 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

Other Forums: Access Forums

All times are GMT -7. The time now is 06:34 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft