Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro beginner - Echo
I have recorded a macro to set the active sheet to Landscape and enter my
name in the left section of the footer as text and set the font size to 8. I have stored it in the Personal Macro Workbook. I use Excel 2003. I have gone into the VB Editor and deleted the parts of the Sub which I dont need. It now reads: Sub LandscapeMyName() ' ' LandscapeMyName Macro ' Macro recorded 09/12/2005 by MyName ' Keyboard Shortcut: Ctrl+Shift+L ' With ActiveSheet.PageSetup ..LeftFooter = "&8MyName" ..Orientation = xlLandscape End With End Sub Years ago, in the ancient days of Excel 6, I remember that there was a possibility to use something along the lines of Echo False, so that the user didnt see any €śflash€ť on the screen. Taking out the bits of the Sub procedure that I dont need helps to eliminate the €śecho€ť but I still get some. Is there a simple way to eliminate it completely? I am definitely not a programmer, just in case there was any doubt ;-), but am a competent user. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro beginner - Echo
You can use
Sub LandscapeMyName() Application.ScreenUpdating = False 'your code Application.ScreenUpdating = True End Sub -- Regards, Peo Sjoblom "Mary Ann" wrote in message ... I have recorded a macro to set the active sheet to Landscape and enter my name in the left section of the footer as text and set the font size to 8. I have stored it in the Personal Macro Workbook. I use Excel 2003. I have gone into the VB Editor and deleted the parts of the Sub which I don't need. It now reads: Sub LandscapeMyName() ' ' LandscapeMyName Macro ' Macro recorded 09/12/2005 by MyName ' Keyboard Shortcut: Ctrl+Shift+L ' With ActiveSheet.PageSetup .LeftFooter = "&8MyName" .Orientation = xlLandscape End With End Sub Years ago, in the ancient days of Excel 6, I remember that there was a possibility to use something along the lines of Echo False, so that the user didn't see any "flash" on the screen. Taking out the bits of the Sub procedure that I don't need helps to eliminate the "echo" but I still get some. Is there a simple way to eliminate it completely? I am definitely not a programmer, just in case there was any doubt ;-), but am a competent user. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro beginner - Echo
Great - thank you
"Peo Sjoblom" wrote: You can use Sub LandscapeMyName() Application.ScreenUpdating = False 'your code Application.ScreenUpdating = True End Sub -- Regards, Peo Sjoblom "Mary Ann" wrote in message ... I have recorded a macro to set the active sheet to Landscape and enter my name in the left section of the footer as text and set the font size to 8. I have stored it in the Personal Macro Workbook. I use Excel 2003. I have gone into the VB Editor and deleted the parts of the Sub which I don't need. It now reads: Sub LandscapeMyName() ' ' LandscapeMyName Macro ' Macro recorded 09/12/2005 by MyName ' Keyboard Shortcut: Ctrl+Shift+L ' With ActiveSheet.PageSetup .LeftFooter = "&8MyName" .Orientation = xlLandscape End With End Sub Years ago, in the ancient days of Excel 6, I remember that there was a possibility to use something along the lines of Echo False, so that the user didn't see any "flash" on the screen. Taking out the bits of the Sub procedure that I don't need helps to eliminate the "echo" but I still get some. Is there a simple way to eliminate it completely? I am definitely not a programmer, just in case there was any doubt ;-), but am a competent user. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can T Get Macro To Run! | New Users to Excel | |||
Closing File Error | Excel Discussion (Misc queries) | |||
Help with macro looping and color query function | Excel Discussion (Misc queries) | |||
Playing a macro from another workbook | Excel Discussion (Misc queries) | |||
Date macro | Excel Discussion (Misc queries) |