Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-24-2014, 09:10 AM
Catty Catty is offline Macro to open the Insert>Cover Page window /dialog box Windows 7 32bit Macro to open the Insert>Cover Page window /dialog box Office 2010 32bit
Advanced Beginner
Macro to open the Insert>Cover Page window /dialog box
 
Join Date: Nov 2013
Posts: 39
Catty is on a distinguished road
Default Macro to open the Insert>Cover Page window /dialog box

Hi, I'm trying to record a macro that will do the following:

1. Select the Insert Tab
2. Cover Page
3. Let the user select a cover page saved in building blocks.

I have tried using Commandbars, but have been unable to locate the Cover Page control.



Any help would be much appreciated. Thanks in advance.
Reply With Quote
  #2  
Old 02-24-2014, 03:45 PM
macropod's Avatar
macropod macropod is online now Macro to open the Insert>Cover Page window /dialog box Windows 7 32bit Macro to open the Insert>Cover Page window /dialog box Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 20,433
macropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant future
Default

If it's a particular cover page you want to insert (i.e. the user doesn't need to choose from the list) you could use a macro like:
Code:
Sub Demo()
Application.Templates("C:\Users\" & Environ("UserName") & _
  "\AppData\Roaming\Microsoft\Document Building Blocks\1033\14\Built-In Building Blocks.dotx") _
  .BuildingBlockEntries("Alphabet").Insert Where:=Selection.Range, RichText:=True
End Sub
Simply change "Alphabet" to whichever one you want to use.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #3  
Old 02-24-2014, 03:53 PM
Catty Catty is offline Macro to open the Insert>Cover Page window /dialog box Windows 7 32bit Macro to open the Insert>Cover Page window /dialog box Office 2010 32bit
Advanced Beginner
Macro to open the Insert>Cover Page window /dialog box
 
Join Date: Nov 2013
Posts: 39
Catty is on a distinguished road
Default

Thanks for your response Macropod. I have recorded this macro, but I need to allow for different cover pages ie. the user will have a number of cover pages to choose from.

Is it possible to call this dialog window using commandbars? I have tried, but I'm obviously failing
Reply With Quote
  #4  
Old 02-24-2014, 06:02 PM
macropod's Avatar
macropod macropod is online now Macro to open the Insert>Cover Page window /dialog box Windows 7 32bit Macro to open the Insert>Cover Page window /dialog box Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 20,433
macropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant future
Default

It may be, but I have no idea of the CommandBar ID for that - IIRC there's something in the order of 10,000 to choose from...
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro to open the Insert>Cover Page window /dialog box How to insert a cover page inbetween each existing page when printing grumby1 Word 6 02-18-2014 07:53 PM
Possible to open each page of file in a different window? Fran71 Word 2 04-27-2012 07:25 PM
Macro to insert new page... samanthaj Word 17 01-31-2012 01:53 PM
Macro to open the Insert>Cover Page window /dialog box Cover page problem bluegum87 Word 2 08-02-2011 09:43 AM
OFFICE(Word,Excel..)-crash/close when DIALOG BOX launched of insert image,open file buggingme Office 1 05-30-2010 12:18 AM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 08:48 PM.


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