Macro recorder and ShowFieldCodes

Jennifer Murphy · #1 11-03-2012, 02:34 PM

I wanted to write a macro to turn off the ShowFieldCodes setting, which somehow got changed. I used the macro recorder to capture the code for turning it on and off. One macro below turned it on and one turned it off. Oddly, they both have the exact same code. Is this a toggle?

Code:

Sub Macro1()
  ActiveWindow.View.ShowFieldCodes = Not ActiveWindow.View.ShowFieldCodes
End Sub
 
Sub Macro2()
  ActiveWindow.View.ShowFieldCodes = Not ActiveWindow.View.ShowFieldCodes
End Sub

I then did a search on this control and found an MSDN article showing that it takes a boolean argument.

http://tinyurl.com/bxprt6b

So, I added this code to my macro, which seems to work.

Code:

  ActiveWindow.View.ShowFieldCodes = False

My questions is, "Why does the macro recorder return the toggle option rather than the explicit settiong?". It did the same thing for TrackRevisions.

macropod · #2 11-04-2012, 01:55 AM

I guess MS programmed the Macro Recorder than way so it didn't have to test the property state and you could use the same code for both actions.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Picture properties bug in Word 2010 Macro Recorder	ralphpickering	Word VBA	5	10-24-2012 10:15 AM
Stumped by the recorder again	Ulodesk	Word VBA	6	07-02-2012 09:23 AM
How do I assign a macro to a button when the macro is in my personal workbook?	foolios	Excel Programming	2	07-27-2011 02:41 PM