Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old Yesterday, 09:19 AM
10xWords/min 10xWords/min is offline Creating Macro:  I don't seem to be able to achieve this Windows 10 Creating Macro:  I don't seem to be able to achieve this Office 2010
Novice
Creating Macro:  I don't seem to be able to achieve this
 
Join Date: May 2019
Location: Suffolk, UK
Posts: 6
10xWords/min is on a distinguished road
Default Creating Macro: I don't seem to be able to achieve this

Windows 10
Word (MS Office 2019)

This is for local college course. I don't think the tutor knows either, to be honest ( )


I'm trying to create a macro to replicate the attached file WEEKLY MENU - JMN.docx. I've tried numerous ways, techiques etc and spent hours recording but something goes wrong every time I've tried to run it.



For what it's worth, I've been assigning Alt + 2 (deleting the previous attempt each time.


Either the table goes wrong (specified 8 cols x 3 rows); used Table designs for the colouring, used mouse to change font, keyboard Ctrl+B/U for the formatting; title size 18 and table font 12.


The bold doesn't always cancel after typing the title. I've highlighted each table cell to cancel Bold using 'shift and arrow keys' / and mouse, but neither have worked properly - characters come out in different cells etc and still in Bold!!!

I'm now wondering if a macro for this is actually feasible. If so, how should I be doing it, please?

Many thanks if you can help me
Reply With Quote
  #2  
Old Yesterday, 09:38 AM
Charles Kenyon Charles Kenyon is offline Creating Macro:  I don't seem to be able to achieve this Windows 11 Creating Macro:  I don't seem to be able to achieve this Office 2021
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,537
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

Why on earth would you use a macro for this?
Just because it is an assignment?
Look into Table Styles for the shading.
Bold, in Word, is a toggle attribute.


The Alt+F3 sounds like you want a macro to change this into a weekly table?
Reply With Quote
  #3  
Old Yesterday, 09:56 AM
10xWords/min 10xWords/min is offline Creating Macro:  I don't seem to be able to achieve this Windows 10 Creating Macro:  I don't seem to be able to achieve this Office 2019
Novice
Creating Macro:  I don't seem to be able to achieve this
 
Join Date: May 2019
Location: Suffolk, UK
Posts: 6
10xWords/min is on a distinguished road
Default

Quote:
Originally Posted by Charles Kenyon View Post
Why on earth would you use a macro for this?
Just because it is an assignment?

Yes, purely an academic exercise. Certainly, a template would be more useful, in the 'real' world


Quote:
Originally Posted by Charles Kenyon View Post
The Alt+F3 sounds like you want a macro to change this into a weekly table?
The Alt+3 is just the keyboard keys I assigned to run it, just because you can and is easy to execute LOL It will never actually be 'used' except by the tutor, if he/she so wishes

Thanks. Yes, I frequently use Ctrl+B/U/I and have done for years. I just added this as detail, trying to explain some of what I tried, in case it was significant to the macro's failure

I'd be pleased to learn if, and how, this can be achieved, as a macro. I'm now having my doubts. I can create macros with text, without a problem. I just can't seem to achieve this 'Weekly Menu' table, for whatever reason.

Hope that explains OK
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Creating Macro:  I don't seem to be able to achieve this Please help me achieve this Zeus Word 2 12-05-2015 09:54 AM
Can't achieve FULL JUSTIFICATION alignment in Word Singh_Edm Word 20 11-20-2015 02:33 AM
Creating Macro:  I don't seem to be able to achieve this in project 2013 standard how to achieve multi-user editting? Lorrainewjh Project 5 07-01-2015 05:57 PM
Must use VBA to achieve conditional formatting along with expanding table columns? tinfanide Excel 0 06-10-2015 12:25 AM
How do you achieve Falling letters? PPT PowerPoint 0 04-21-2012 06:12 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:42 PM.


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