Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-15-2013, 02:16 PM
Cosmo Cosmo is offline Macrobutton shifts view when document is protected for forms Windows Vista Macrobutton shifts view when document is protected for forms Office 2007
Competent Performer
Macrobutton shifts view when document is protected for forms
 
Join Date: Mar 2012
Posts: 240
Cosmo is on a distinguished road
Default

Quote:
Originally Posted by Charles Kenyon View Post
Thank you for the update. Again, I learn something new!
This is the code I ended up using in a MacroButton Controller class:

Code:
Option Explicit
Private WithEvents wordApp As Word.Application
Private currentButtonClick As Integer
Private TemplateDoc As Document
'*************************************************************************
' Initialize class - Create objects and set values to defaults.
'*************************************************************************
Private Sub Class_Initialize()
    currentButtonClick = Options.ButtonFieldClicks
    Set wordApp = Application
    Set TemplateDoc = ActiveDocument
    Call setButtonClick
End Sub
'*************************************************************************
' Terminate class - Cleanup code.
'*************************************************************************
Private Sub Class_Terminate()
    Call restoreButtonClick
    Set wordApp = Nothing
    Set TemplateDoc = Nothing
End Sub
'*************************************************************************
' Application EVENT HANDLERS
'*************************************************************************
Private Sub wordApp_DocumentBeforeClose(ByVal Doc As Document, Cancel As Boolean)
    If CheckDoc(Doc) Then
        Call restoreButtonClick
    End If
End Sub
Private Sub wordApp_WindowActivate(ByVal Doc As Document, ByVal Wn As Window)
    If CheckDoc(Doc) Then
        Call setButtonClick
    End If
End Sub
Private Sub wordApp_WindowDeactivate(ByVal Doc As Document, ByVal Wn As Window)
    If CheckDoc(Doc) Then
        Call restoreButtonClick
    End If
End Sub
''*************************************************************************
'' UTILITY functions
''*************************************************************************
Private Function CheckDoc(Doc As Document) As Boolean
    If Not (TemplateDoc Is Nothing) Then
        If Not (Doc Is Nothing) Then
            CheckDoc = (Doc = TemplateDoc)
        End If
    End If
End Function
Private Function setButtonClick()
    Options.ButtonFieldClicks = 1
End Function
Private Function restoreButtonClick()
    Options.ButtonFieldClicks = currentButtonClick
End Function
I appreciate the help, I wouldn't have known that there was a setting for this without your responses. Thanks again
Reply With Quote
  #2  
Old 10-15-2013, 03:28 PM
Charles Kenyon Charles Kenyon is offline Macrobutton shifts view when document is protected for forms Windows Vista Macrobutton shifts view when document is protected for forms Office 2010 32bit
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,592
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

Very nice. Beyond my pay grade!
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Macrobutton shifts view when document is protected for forms Disable Protected View in Microsoft Excel kwon34 Excel 2 09-27-2013 08:38 PM
Macrobutton shifts view when document is protected for forms Cannot open emailed documents in Word 2010 - Protected View Andrewjmarino Word 8 09-05-2013 03:58 PM
Macrobutton shifts view when document is protected for forms Spell checker in Word protected forms Frankwlc Word 3 08-02-2013 12:15 PM
Using bookmarks in a protected document Bill Stemp Word 0 10-16-2010 06:47 AM
MacroButton MednataMiza Word 0 06-29-2010 01:59 AM

Other Forums: Access Forums

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