Dear Paul
Thanks for the reply.
The sheet has been used in the organisation for long time and there is
no current owner of it.
Currently the workbook is Excel 2007 version. It is simply a
spreadsheet with xlsm extension and no application or like that. It
has xls extension in 2009 but during the upgradation to MS Office
2007, the extension changed to xlsm.I can open vba editor but there is
no code.Also no macros.
When I click Record macro and press any of two buttons, nothing
happens and in vba code there is following code:
Sub Macro1()
'
'
End Macro1
Please advise what can be done with that sheet. The buttons works
fine, but I cannot make any change.
Regards
Anil
On Jan 7, 1:53 am, Paul Schreiner <schreiner_p...@att.net> wrote:
> What version of Excel are you using?
> Is it the "spreadsheet" application that used to come with Windows
> rather than an msOffice application?
>
> WAY back in Excel version... 4? they didn't use a VBA editor.
> Instead, you created a sheet called "macro#" and wrote your
> scripting there.
> It wasn't really VBA, it was more like a "scripting" language.
> I haven't done that in many, many years.
>
> I THINK it had a macro recorder funcion.
> Perhaps you could "record" your steps and see what scripting is created?
>
> otherwise, we'll need to know what version of Excel you're using
> and perhaps we can find someone with expertise with it.
>
> sorry,
>
> Paul
>
> ________________________________
> From: anil <dhi...@gmail.com>
> To: MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com>
> Sent: Wed, January 5, 2011 6:11:57 PM
> Subject: $$Excel-Macros$$ Understand macro code in timesheet
>
> 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 athttp://www.excel-macros.blogspot.com
> 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below
> linkhttp://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&;...
--
----------------------------------------------------------------------------------
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/discussexcel
