rightfoot
  Home FAQ Contact Sign in
 
 Advanced search
MATCHING GROUPS



more...
POPULAR GROUPS

more...
found 165 articles for 0.304 sec
If you must write a program to do it, you can find information here on how. http://www.cpearson.com/excel/vbe.aspx I agree with Don though. I'd have them send the workbook to modify and send it back. -- HTH, Barb Reinhardt "Karin" wrote: > Thank you -- however, that doesn't remove the Before_Print code which puts > the footer back in, so it doesn't work. I can delete the     

Group: microsoft.public.excel.misc · Group Profile · Search for rightfoot in microsoft.public.excel.misc
Author: Barb Reinhardt
Date: Sep 20, 2008 15:34

If you want it completely disabled, remove the BeforePrint procedure. Otherwise, you'll need to provide more information on when you don't want it used so that we can assist with code changes. -- HTH, Barb Reinhardt "Karin" wrote: Thank you -- however, that doesn't remove the Before_Print code which puts the footer back in, so it doesn't work. I can delete the code, but
Show full article (2.80Kb) · Show article thread
There is code available to change code but have you considered having your friend email you the workbook for you to change and email back? -- Don Guillett Microsoft MVP Excel SalesAid Software dguillett1@austin.rr.com "Karin" <Karin@discussions.microsoft.com> wrote in message news:22D33C2D-A771-4371-A1F3-C783B233E9FD@microsoft.com... > Thank you -- however, that doesn't remove the Before_Print     

Group: microsoft.public.excel.misc · Group Profile · Search for rightfoot in microsoft.public.excel.misc
Author: Barb Reinhardt
Date: Sep 20, 2008 15:16

Thank you -- however, that doesn't remove the Before_Print code which puts the footer back in, so it doesn't work. I can delete the code, but the person I'm trying to help doesn't know much about excel - I am trying to find an automated way to remove this code. "Barb Reinhardt" wrote: No macro needed. Have her select all of the sheets and then change the footer. It will change
Show full article (2.79Kb) · Show article thread
No macro needed. Have her select all of the sheets and then change the footer. It will change all of them at once. -- HTH, Barb Reinhardt "Karin" wrote: > Actually, I just realized that there is code in the workbook that puts the > footer on -- it's on This Workbook -- how can I write something that disables > this code completely? This is for someone in our office who gets     

Group: microsoft.public.excel.misc · Group Profile · Search for rightfoot in microsoft.public.excel.misc
Author: Don Guillett
Date: Sep 20, 2008 15:15

Actually, I just realized that there is code in the workbook that puts the footer on -- it's on This Workbook -- how can I write something that disables this code completely? This is for someone in our office who gets these various reports in monthly and needs to remove the footer on all worksheets -- the file changes so I need a macro she can run over and over. TIA "Karin" wrote:
Show full article (2.87Kb) · Show article thread
Hi, I've attached the previous correspondence, but it was a while ago, so I wasn't sure anyone would see it. The problems is that it seems to go to next sheet and on from there without changing the sheet you are on or the sheets before it. "Jim Thomlinson" wrote: > There is a problem wiht doin a pagesetup to all sheets. VBA can only do it > one sheet at a time... Your code is equivalent     

Group: microsoft.public.excel.misc · Group Profile · Search for rightfoot in microsoft.public.excel.misc
Author: Karin
Date: Sep 20, 2008 14:43

It seems to go to next sheet and on from there without changing the sheet you are on or the sheets before it. "Jim Thomlinson" wrote: There is a problem wiht doin a pagesetup to all sheets. VBA can only do it one sheet at a time... Your code is equivalent to Worksheets.Select Activesheet.PageSetup.RightFooter = "" '**Activesheet only Sheets(1).Select Range
Show full article (2.41Kb) · Show article thread
I found this to be EXACTLY what I needed to create a macro that can be run over and over to change a page footer. The document comes in monthly from outside and this needs to be changed every month. Thank you! "Earl Kiosterud" wrote: > Frank, > > This is about the dumbest reply that's been seen for a while. Too much > trouble. Use Paul's suggestion instead (unless there are other     

Group: microsoft.public.excel.misc · Group Profile · Search for rightfoot in microsoft.public.excel.misc
Author: Barb Reinhardt
Date: Sep 20, 2008 14:35

There is a problem wiht doin a pagesetup to all sheets. VBA can only do it one sheet at a time... Your code is equivalent to Worksheets.Select Activesheet.PageSetup.RightFooter = "" '**Activesheet only Sheets(1).Select Range("A1").Select Try this... It does not select anything so your user will be left exactly where they were when the started the macro. Sub test()
Show full article (1.99Kb) · Show article thread
    

Group: microsoft.public.excel.misc · Group Profile · Search for rightfoot in microsoft.public.excel.misc
Author: Karin
Date: Sep 20, 2008 14:13

Show full article (1.72Kb) · Show article thread
    

Group: microsoft.public.excel.misc · Group Profile · Search for rightfoot in microsoft.public.excel.misc
Author: Karin
Date: Sep 20, 2008 14:07

Show full article (1.24Kb)
    

Group: microsoft.public.excel.misc · Group Profile · Search for rightfoot in microsoft.public.excel.misc
Author: Karin
Date: Sep 20, 2008 14:01

Show full article (1.10Kb) · Show article thread
    

Group: microsoft.public.excel.misc · Group Profile · Search for rightfoot in microsoft.public.excel.misc
Author: Karin
Date: Sep 18, 2008 11:45

Show full article (2.14Kb)
    

Group: microsoft.public.excel.misc · Group Profile · Search for rightfoot in microsoft.public.excel.misc
Author: Jim Thomlinson
Date: Sep 18, 2008 11:41

Show full article (0.89Kb) · Show article thread
1 · 2 · 3 · 4 · 5 · 6 · 7 · 8 · 9 · next