LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 15
Default Excel 2003 - Toggle formulae display ON/OFF on worksheet

I've created a macro to do this, but I was sure that there was a shortcut key
already in Excel 2003 to do this. Here's how my macro looks:

Sub ToggleFormulaOnOff()
FormulaStatus = ActiveWindow.DisplayFormulas
ActiveWindow.DisplayFormulas = Not FormulaStatus
End Sub

Does anyone know the existing shortcut?
Thanks in advance!

Cheers
Training Goddess

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can't toggle (or display) formula bar DES1944 Excel Discussion (Misc queries) 5 June 29th 06 12:14 AM
"Toggle total row" button not enabled in Excel 2003 dominic_howden Excel Discussion (Misc queries) 0 April 12th 06 09:21 AM
Can't toggle function results display. W. J. Settegast Excel Discussion (Misc queries) 0 February 16th 06 10:33 PM
EXCEL 2003 formulae EXCEL formulae Excel Discussion (Misc queries) 2 August 1st 05 01:10 AM
Is there a way to toggle cells between display of referenced data. williejoeshaver Excel Discussion (Misc queries) 3 March 11th 05 11:22 PM


All times are GMT +1. The time now is 06:13 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"