Hi Asa At the moment the H1 setting makes no difference. The sheet works like normal with the setting at activate or deactivate, and not in tab order. Thanks Charlie
On Sun, Mar 4, 2012 at 10:09 PM, Asa Rossoff <a...@lovetour.info> wrote: > Hi Charlie,**** > > The "button" is actually just a cell that is colored. It has Data > Validation enabled for that cell that restricts values to "Activate" and > "Deactivate".**** > > ** ** > > The "tab order" macro seems to be pretty straightforward and I would > expect it to work with Excel 2000, but I am not an expert at what is and is > not supported.**** > > ** ** > > The macro moves the selection to the next data entry cell only when a cell > is edited. *Not* particularly when tab is pressed.**** > > ** ** > > Can you confirm that when cell "H1" says "Activate" and you edit one of > the cells listed at the end of this sentence and hit either tab or enter to > leave the cell that the selection does not go to the next cell in this > list: h8, h9, h10, h11, h13, l11, l12, h17, k17, h18, k18, k21, k22, n26, > n27, n31, k37, e82, f82, h82, j82, e83, f83, h83, j83, e84, f84, h84, j84, > e85, f85, h85, j85, e86, f86, h86, j86, e87, f87, h87, j87, e88, f88, h88, > j88, e89, f89, h89, j89?**** > > ** ** > > Asa**** > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Cab Boose > *Sent:* Saturday, March 03, 2012 10:07 PM > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-Macros$$ Turn Tab Order on/off**** > > ** ** > > HI**** > > **** > > In attached workbook Ashish has produced a great macro but he is not use > to XL2000, only later ones.**** > > **** > > There is a button at top of worksheet to turn on/off the macro that sets > the tab order. Not working currently, is there an adjustment to make for > XL2000 ?**** > > Once going, please check when in tab order mode that if a entry is > incorrect and user hits delete for that cell that it does not delete info > in all tabbed cells.**** > > **** > > Your assistance appreciated.**** > > **** > > Charlie**** > > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > ------------------------------------------------------------------------------------------------------ > To post to this group, send email to excel-macros@googlegroups.com**** > > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > ------------------------------------------------------------------------------------------------------ > To post to this group, send email to excel-macros@googlegroups.com > -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com
