Hi Asa and Don Thanks for all your comments and help.
Now I see what it is doing, as you explained in your emails. Yes it does work, in quite a different way to what I was expecting. My apologies for being so dumb. With this sheet it is normally filled in once and not all of the tabbed cells will be used. I need to be able to keep tab/enter until the cell is reached that needs to have an entry and then on to the next cell that has an entry. To be able to make changes in cells other than the tabbed cells I need to be able to unlock the tab sequence make the change and then lock again so that the tab sequence is being used again. This will not happen very often. Mostly in tab mode. Yes I am using Excel2000. Going to upgrade sometime soon. It appears then that I have not got the right vba code to switch the tab code on and off, and that when tab order locked in that it only goes to the tab order codes. Hope I have explained clear enough. Thanks and regards Charlie Harris On Sun, Mar 25, 2012 at 3:11 AM, Asa Rossoff <a...@lovetour.info> wrote: > Yeah, I realize -- he's on 2000. Nothing jumped out at me in the > macro/workbook he's discussing that obviously relied on any new features. > I can't claim to be the ultimate version expert though.**** > > Asa**** > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *dguillett1 > *Sent:* Saturday, March 24, 2012 7:07 AM > > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Turn Tab Order on/off**** > > ** ** > > I haven’t followed this but I think Charlie has a older version ( if that > makes a difference) ??**** > > **** > > Don Guillett > Microsoft MVP Excel > SalesAid Software > dguille...@gmail.com**** > > **** > > *From:* Asa Rossoff <a...@lovetour.info> **** > > *Sent:* Saturday, March 24, 2012 2:27 AM**** > > *To:* excel-macros@googlegroups.com **** > > *Subject:* RE: $$Excel-Macros$$ Turn Tab Order on/off**** > > **** > > Hi Charlie, Good day -**** > > I'm not sure what the trouble is.**** > > **** > > Works in Excel 2010.**** > > **** > > Just to reiterate, the macro does not make the tab key go from field to > field. It only has effect when a field (listed cell) is edited. What the > macro does: after you've edited a cell in the list, it selects the next > cell in the list. If you don't edit a cell, the macro does nothing, and > you can tab all over the place.**** > > **** > > to troubleshoot the macro, you can go in the VBE/macro editor (Alt-F11) > and set a breakpoint on a line in the macro. To set a breakpoint, you can > hit F9 on a line. Then the macro will stop on that line (if the macro runs > at all). If it doesn't run, then that would explain why it doesn't do > anything and we can try to figure out why. If it does run, the macro > editor will pop up on the screen with the macro running but paused. You > can then hit F8 to execute one line at a time (or Debug menu -> Step Into > for the same). See if you can figure out where the marco is failing you.* > *** > > **** > > Give it a shot, and post back. I can try to help you debug it if you need > more help. It's kind of hard to do by email like this, though.**** > > **** > > Asa**** > > **** > > *From:* excel-macros@googlegroups.com [ > mailto:excel-macros@googlegroups.com <excel-macros@googlegroups.com>] *On > Behalf Of *Cab Boose > *Sent:* Saturday, March 17, 2012 2:47 PM > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Turn Tab Order on/off**** > > **** > > Good Day Asa**** > > **** > > Are you able to assist with this for me. Would be greatly appreciately.** > ** > > Thanks**** > > Charlie**** > > On Wed, Mar 14, 2012 at 9:45 AM, Cab Boose <swch...@gmail.com> wrote:**** > > 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**** > > -- > 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 > -- 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
