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

Please Login or Register  to view this content.

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.