Problem - I have one spreadsheet which is used to record our time
sheet in office. Sheet 1 is named Macro1 and has following code/lines
in the cells starting from A1 till A18:
Next Fortnight
=ECHO(FALSE)
=SELECT("R56C13")
=COPY()
=SELECT("R9C15")
=PASTE.SPECIAL(3,1,FALSE,FALSE)
=SELECT("R10C4:R49C5")
=CLEAR(3)
=SELECT("R12c10:R13c10,R16c10:R17c10,R20c10:R21c10,R24c10:R25c10","R24c10")
=CLEAR(3)
=SELECT("R28c10,R28c10:R29c10,R32c10:R33c10,R36c10:R37c10,R40c10:R41c10,R44c10:R45c10,R48c10:R49c10","R48c10")
=CLEAR(3)
I=FLEXY!$B$12
I=I+14
=SELECT("R10C4")
=FORMULA(I,FLEXY!$B$12)
=CALCULATE.NOW()
=RETURN()In second sheet named 'TimeSheet' we have to enter time in and time out and it calculates total time and credit. There are 2 buttons on the sheet - 'Next fortnight' and 'Re- Calculate'. No code in visual basic window at all. When I right click 'Next fortnight' and select 'Assign macro' - It goes to second line of the code - "=ECHO(FALSE)" When I right click Re-Calculate' and select 'Assign macro' - It goes to second line of the code - "=CALCULATE.NOW()" I want to make few changes like copy fortnight data to new blank sheet and few other minor bits, but completly clueless how to make any change. Can you please guide me how can I make any changes in the spreadsheet? Is the macros locked? Thanks in advance -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
