Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #5  
Old 11-05-2015, 06:11 PM
macropod's Avatar
macropod macropod is offline Hide Macro Button when printing Windows 7 64bit Hide Macro Button when printing Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,516
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Well, there are field coding solutions (i.e. no macros required) that should work regardless of document protection. To provide instructions that disappear
• permanently once the document is printed, you could use a field coded as:
{IF{PRINTDATE \@ yyyy}= 0 "Instructions"}
• temporarily when the document is printed, you could use a field coded as:
{IF{PRINTDATE \@ yyyyMMddHHmm}= {DATE \@ yyyyMMddHHmm} "" "Instructions"}
With this second approach, the instructions can be made to re-appear via anything that causes the fields to update (e.g. a print preview or tabbing out of a formfield that has the 'calculate on exit' property set) but you may have to wait for up to a minute after printing to do that.

The alternative is to code the macro to temporarily switch off protection while updating the Style/formatting.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Hide Macro Button when printing Want to show/hide mutiple grouped coloumns in Excel sheet with a button abutahir Excel 4 11-03-2015 01:07 PM
How to hide the Audio Icon while PRINTING chrismhart PowerPoint 1 10-30-2014 03:33 PM
Hide Macro Button when printing Hide Checkbox When Printing vinceplunkett Word 1 12-03-2013 01:53 AM
Hide Macro Button when printing Assign macro but hide the button/field trlear Word VBA 5 02-23-2012 04:35 PM
Hide Macro Button when printing Button in hidden section won't hide Joe Patrick Word 6 06-07-2011 09:31 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:12 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