OK. Thanks for the input, Dave. On Jul 3, 1:04 am, Dave Bonallack <davebonall...@hotmail.com> wrote: > Hi Doug, > > All formatting can be done through VBA. > > But if you want the formatting applied to each cell as you click on it, then > you need an event macro, which needs to reside in the code window of that > sheet. So each day when you create a new sheet, you'd have to paste in the > VBA code as well. My guess is that the way you are doing it now, is best. But > let me know if there's a pressing reason to use VBA instead. > > Regards - Dave > > > > > Date: Thu, 2 Jul 2009 03:55:36 -0700 > > Subject: $$Excel-Macros$$ Re: A question about conditional formatting > > From: dsrmccl...@gmail.com > > To: excel-macros@googlegroups.com > > > Dave, > > That's exactly how I'm doing it now. I'm just wondering if each cell > > could call a sub that would do the formatting on the fly and not hard > > code it with each sheet. If there would be any advantage if it could > > be done. > > > On Jul 1, 10:29 pm, Dave Bonallack <davebonall...@hotmail.com> wrote: > > > Hi Doug, > > > > I think I would keep a sheet in the workbook called 'Template' which > > > contains all the formatting you want. Then each day, make a copy of that > > > sheet, and rename the copy as needed. Don't ever put data into your > > > Template sheet. Just use it to create new sheets. > > > > Regards - Dave. > > > > > Date: Wed, 1 Jul 2009 08:55:34 -0700 > > > > Subject: $$Excel-Macros$$ A question about conditional formatting > > > > From: dsrmccl...@gmail.com > > > > To: excel-macros@googlegroups.com > > > > > Just a quick question. > > > > > I'm writing a workbook in which a new worksheet will be added every > > > > day. Each worksheet contains a number of cells with the same > > > > conditional formatting applied. Is there any advantage to applying the > > > > formatting through VBA code as opposed to applying it through the > > > > Format menu? I'm thinking about how this workbook will grow in size as > > > > new sheets are added. > > > > > Thank you. > > > > _________________________________________________________________ > > > Looking for a place to rent, share or buy this winter? Find your next > > > place with Ninemsn > > > propertyhttp://a.ninemsn.com.au/b.aspx?URL=http%3A%2F%2Fninemsn%2Edomain%2Eco...Hide > > > quoted text - > > > > - Show quoted text - > > _________________________________________________________________ > View photos of singles in your area Click > Herehttp://dating.ninemsn.com.au/search/search.aspx?exec=go&tp=q&gc=2&tr=...
--~--~---------~--~----~------------~-------~--~----~ ---------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~----------~----~----~----~------~----~------~--~---
