Results 1 to 9 of 9

How to create a macro button to clear muliple cells on multiple worksheets

Threaded View

nje How to create a macro button... 07-02-2014, 03:23 PM
AB33 Re: How to create a macro... 07-02-2014, 03:48 PM
PCI Re: How to create a macro... 07-02-2014, 03:49 PM
JOHN H. DAVIS Re: How to create a macro... 07-02-2014, 03:52 PM
stephenloky Re: How to create a macro... 07-02-2014, 03:58 PM
nje Re: How to create a macro... 07-02-2014, 03:59 PM
AB33 Re: How to create a macro... 07-02-2014, 04:05 PM
PCI Re: How to create a macro... 07-02-2014, 04:15 PM
nje Re: How to create a macro... 07-03-2014, 06:06 AM
  1. #1
    Valued Forum Contributor
    Join Date
    06-23-2010
    Location
    North West
    MS-Off Ver
    office 2010
    Posts
    355

    How to create a macro button to clear muliple cells on multiple worksheets

    Good Evening
    I have attached a test workbook excel 2010 (please ignore ref# errors, I've cut the workbook down for uploading purposes)
    What I would like to do is have a 'Button' on my 'information Sheet' which when clicked would clear certain cells.
    I have searched the forum but can't find a solution, everyone seems to want to delete rows or columns but I just want to clear certain cells.
    The workbook will have 11 sheets each named 'caravan 1' through to 'caravan 11'
    The uploaded test workbook only only has 3 sheets.

    On 'caravan 1' (which is slightly different to the other 10) I want to clear the content of cells

    B4 & B5
    C4, C22 & C41
    D4 & D5
    E4,E5, E22,E23,E41 &E 42

    On all other 'Caravan sheets' I want to clear the contents of cells

    D4 & D5
    E4, E5, E22, E23, E41 & E42

    It would be icing on the cake if it could give a warning such as " are you sure you want to clear these cells" but that isn't really necessary.
    The worksheets will be password protected, but the cells mentioned above will not be.
    If it proves too difficult to clear all the cells on all the sheets with one click, then perhaps a simpler solution might be to have a button on each sheet instead

    Thanks
    Attached Files Attached Files
    Last edited by nje; 07-02-2014 at 03:48 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Macro Button To Clear Certain Cells
    By mohannah in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-26-2014, 04:07 AM
  2. [SOLVED] create a 'button' to click to clear cells
    By OAKLEY in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 01-13-2014, 07:12 AM
  3. Macro Button To Clear Certain Cells
    By TroyDurham in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 01-28-2009, 03:33 AM
  4. Create a button to clear data in certain cells
    By headbanger51 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-07-2008, 03:18 AM
  5. Create a button to Clear Cells
    By tamato43 in forum Excel General
    Replies: 3
    Last Post: 05-15-2005, 10:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1