cross hair
in [General]
|
From: johnpotter94501 on 23 Nov 2009 20:55 Rick the code worked fine except when i close the file it won't work again . also can i defult this to the workbook john -- Mr. Coffee "johnpotter94501" wrote: > i am a teacher and use excell for grades . Names on top assignments on the > right side. i am trying to make cross hairs what ever cell i click into i > will see a color line vertical and horsonal to help me make sure the right > grades are entered. i have office 2007 pro. > -- > Mr. Coffee
From: Rick Rothstein on 24 Nov 2009 03:23 Which code are we talking about, the SelectionChange event code (which should work when you open the workbook again) or the macro version (which requires you to start it each time you open the workbook)? As for defaulting the code to the workbook "john"... if you put it in that workbook, it should be available whenever you open that workbook. Perhaps if you can provide more detail describing what you want to happen, then we won't have to try and guess at what you are ultimately looking for. -- Rick (MVP - Excel) "johnpotter94501" <johnpotter94501(a)discussions.microsoft.com> wrote in message news:BFC9432A-6EB5-4FAA-AB90-D5E41E2B2CE4(a)microsoft.com... > Rick the code worked fine except when i close the file it won't work again > . > also can i defult this to the workbook john > -- > Mr. Coffee > > > "johnpotter94501" wrote: > >> i am a teacher and use excell for grades . Names on top assignments on >> the >> right side. i am trying to make cross hairs what ever cell i click into i >> will see a color line vertical and horsonal to help me make sure the >> right >> grades are entered. i have office 2007 pro. >> -- >> Mr. Coffee
From: Max on 24 Nov 2009 08:18 Superb! Many thanks for your solution, Rick.
First
|
Prev
|
Pages: 1 2 Prev: Outlook 2007 crashes Next: Excel Renaming Files When Opening Using File Convertor |