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
