Put this in the ThisWorkbook code module and adjust your range(s) t
suit
Code
-------------------
Private Sub Workbook_Open(
Sheets("Sheet1").Range("A1:C1,B3,A10:F12,G10").ClearContent
End Su
-------------------
*How to Save a Workbook Event Macro*
1. *Copy* the macro above placing the cursor to the left of th
code box hold the *CTRL & Left Click,* then *Right Click* selected cod
and *Copy.*
2. Open your Workbook and *Right Click* on any *Worksheet's Name Tab*
3. *Left Click* on *View Code* in the pop up menu.
4. Press *ALT+F11* keys to open the *Visual Basic Editor.*
5. Press *CTRL+R* keys to shift the focus to the *Project Explore
Window*
6. Press the *Down Arrow Key* until *ThisWorkbook* is highlighted i
blue.
7. *Press* the *Enter* key to move the cursor to the *Code Window*
8. *Paste* the macro code using *CTRL+V*
9. *Save* the macro in your Workbook using *CTRL+S
I have a data entry Sheet for loading details to Invoice (sheet 1) an
thi
data entry sheet loads as soon as file opens. It open with the cell
still with old datas in, is there a way of either the cells being empt
whe
next data load or actually clearing after use / enter the buttom
(macro)
OK / Next
Rdgs
Sudipt
--
Simon Lloy
Regards
Simon Lloy
'Microsoft Office Help' (
http://www.thecodecage.com