Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) |