Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
updated from office 2000 - 2003 | Excel Discussion (Misc queries) | |||
Office 2000/Office 2003 Excel not printing landscape vise versa | Setting up and Configuration of Excel | |||
In Excel 2000, Cannot edit cells in worksheet created in 2003? | Excel Discussion (Misc queries) | |||
HOW CAN I READ SPREADSHEETS CREATED BY OFFICE 2000 ON OFFICE 2003. | Excel Worksheet Functions | |||
Win98 SE, Office 2000: ODBC from Excel behaves strangely on one computer | Excel Discussion (Misc queries) |