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)? -- 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.