How do I create a "reset macro" to set my workbook back to start

**jamierat** · 12-30-2011, 02:22 PM

I want a button that will reset my workbook, uncheck boxes, set qtys to 0, etc basically set it to exactly how I have it right now. Thanks for the help

**dilipandey** · 12-31-2011, 01:50 AM

Hi jamierat,

See the attached workbook where I have done this on the first sheet and assigned the macro to the button which you had already created. Press Alt + F11 and check the module, its quite simple and you can easily amend the code for rest of the sheets

Cheers

Regards,
DILIPandey

<click on below 'star' if this helps>

**JieJenn** · 12-31-2011, 02:20 AM

This might do the trick

Sub clear()
Union(Range("B15:B30"), Range("F15:G30")).ClearContents
End Sub

**XLent** · 12-31-2011, 03:16 AM

JieJenn, Union ?

Range("B15:B30,F15:G30").ClearContents

**JieJenn** · 12-31-2011, 03:29 AM

Just a habit. Sometimes ranges can get too many for me.

**JieJenn** · 12-31-2011, 03:24 AM

Yeah Union or Range("B15:B30, F15:G30"); both works.

**XLent** · 12-31-2011, 03:26 AM

To be clear - it wasn't a question rather to express surprise at your usage of it.

How do I create a "reset macro" to set my workbook back to start

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

How do I create a "reset macro" to set my workbook back to start

Re: How do I create a "reset macro" to set my workbook back to start

Re: How do I create a "reset macro" to set my workbook back to start

Re: How do I create a "reset macro" to set my workbook back to start

Re: How do I create a "reset macro" to set my workbook back to start

Re: How do I create a "reset macro" to set my workbook back to start

Re: How do I create a "reset macro" to set my workbook back to start

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions