View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
DORI DORI is offline
external usenet poster
 
Posts: 35
Default VBA for Clearing data from the worksheet

Is it possible to press a cell on the worksheet to clear all entered data in
the entire worksheet?
I have a worksheet that users enter several data in different pages and then
print a report. The next user will have to clear all eneries and then enter
their own data before printing the next report. At this time, we close the
program and reopen it which is a bit of pain, just wondering if thee is a VBA
code to activate create a key (let call it "Reset all Forms" on the worksheet
to press and clear all data.
I appreciate any comments in advance.
Dori