Create a macro to blank cells in a specific workbook - Excel 2003

[Elmer]

Hi -

I was wondering if someone might be able to help. At work we use a spreadsheet template that we pass from group to group which contains (6) worksheets. One of the worksheets contains a number of cells which are confidential, and I'd prefer that infomation not be passed on to my group.

I'd like to create a "button" (or macro) which would clear data from these specific cells on this specific worksheet before they are sent to my team. I'm a macro newbie, and I'd appreciate any assistance anyone could provide.

Thanks in advance.

[VBA Noob]

Press Alt + F11 > insert module > paste in the below. Change sheet name and range to suit

Sub ClearCells()
Dim Rng As Range
'Change Sheet name to your sheet Name
'Change Range to your range e.g Range("A1:A10")
Set Rng = Sheets("Sheet1").Range("E3,B1,A4,C7")
    Rng.ClearContents
End Sub

To run press Alt + F8

VBA Noob

[davesexcel]

Hi -

I was wondering if someone might be able to help. At work we use a spreadheet template that we pass from group to group which contains (6) worksheets. One of the worksheets contains a number of cells which are confidential, and I'd prefer that infomation not be passed on to my group.

I'd like to create a "button" (or macro) which would clear data from these specific cells on this specific worksheet before they are sent to my team. I'm a macro newbie, and I'd appreciate any assistance anyone could provide.

Thanks in advance.

Here's a link on starting the macro recorder
http://www.exceltip.com/st/Using_the...Excel/627.html

[Elmer]

Thank you - it worked like a champ!!!!! Your help is greatly appreciated.