Hi can you share sample files... +++++ *I did not do this for you. God is here working through me for you.*
On Mon, Oct 20, 2014 at 3:34 AM, Robert Baer <robertgurrb...@gmail.com> wrote: > > > On Saturday, October 18, 2014 8:16:05 PM UTC-7, Robert Baer wrote: >> >> Assume one has a spreadsheet with some titles and column headings, >> along with a row of data already filled out by an automated copy from a >> previous "journal". >> Pardon this is long; think i have given all what i want out of this >> Excel "program". >> >> Assume previous journal (sheet) had a number,want this new one to be >> given (show) in $B$4 the next number. Want $B$3 to be current date. After >> that, want all cells $A$1 to $P$8 to be locked out from any attempt to >> change; better yet, no visiting allowed. >> Input cell at this time is $A$9 and input cell is advanced to $B$9; after >> contents are verified to be integer numeric,then that cell is locked and >> only then input cell is advanced for next entry and that is verified >> according to preset rules for that cell, which is then locked out. >> This continues to right up to and including $I$9; values are calculated >> for cells $J$9 to $P$9; and then all of those cells are locked out. >> At this point,row 9 is locked and this process is repeated for row 10, >> etc to row 33. >> Row 35 accumulates sums for the appropriate columns, and the user is >> locked out from making changes. Row 6 values and row 35 get added into row >> 37 and is similarly locked. >> Column K is calculated as a receipt number,incrementing as each row is >> completed by the user. Per rules above, the user is locked out and cannot >> change it. >> Rows not filled out by user remain empty. >> >> Then a new "journal"/sheet is made with old row 37 copied to new row 6, >> the journal number is incremented and the locking and forced data entries >> as mentioned continue. >> >> HOW can this be done (Excel 2003)? >> > ** Easily found way to "go to" a given cell for data entry: > Range(RowStart).Select. > However, there seems to be no way to have the script wait for user > input (and then check appropriate conditions) before going to next logical > step. > If that can be done, it seems i could write the script to do most of > what i want. > The locking out i want would seem to be yet another problem. > Suggestions? > Thanks. > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 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) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
