Worksheet created in Office 2000 - updated computer to 2003
 

Okay, this is ancient history for some of you guys. Don't ask.
Situation:
Worksheet used as a "time card" calculates daily time. Has a section that
keeps track of leave time available, sick time available. There are a few
steps that round exact time obtained to even hours and half hours but i don't
think this is relevant to my problem.
At the beginning of the next pay period i could point to a vacant cell,
press ctrl, alt r (the letter "r") and all data that had been entered and the
resulting calculations reset to blank cells. The leave time available and
sick time available updated to reflect changes during the previous pay
period.
In Office 2003 I do the ctrl, alt,r and nothing happens. My Head of
Automation has changed the security level on the macros so that they run.
Well, we can only see one - and it runs.
How did the creator of the worksheet perform the "reset" in the 2000
version? How can I get the 2003 version to perform this function?


Plee

Worksheet created in Office 2000 - updated computer to 2003
 

I assume you using the same worksheet? XL2003 has no problem opening XL2000
worksheets (and visa versa).

You need to locate the subroutine that did the 'clean up'
Use ALT+F11 to open the VBA editor
Look at the various subroutines
Even if you know no VBA you should be able to find the one that does the
job; it might have code like: Range(A1:A12).Clear
Then in Excel, use Tools | Macros and look for the name of the subroutine
that does the clear up
Click the Option button in the Macro dialog and you can set the shortcut the
CTRL+R
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Plee" wrote in message
...
Okay, this is ancient history for some of you guys. Don't ask.
Situation:
Worksheet used as a "time card" calculates daily time. Has a section that
keeps track of leave time available, sick time available. There are a few
steps that round exact time obtained to even hours and half hours but i
don't
think this is relevant to my problem.
At the beginning of the next pay period i could point to a vacant cell,
press ctrl, alt r (the letter "r") and all data that had been entered and
the
resulting calculations reset to blank cells. The leave time available and
sick time available updated to reflect changes during the previous pay
period.
In Office 2003 I do the ctrl, alt,r and nothing happens. My Head of
Automation has changed the security level on the macros so that they run.
Well, we can only see one - and it runs.
How did the creator of the worksheet perform the "reset" in the 2000
version? How can I get the 2003 version to perform this function?


Plee