+ Reply to Thread
Results 1 to 2 of 2

Reset Button

  1. #1
    Registered User
    Join Date
    02-18-2014
    Location
    Gold Coast, Australia
    MS-Off Ver
    Office 365
    Posts
    8

    Reset Button

    Hi,

    I have sheet where I have set a rest button that clears date and adds a number when it is reset.
    as part of the reset process it brings up the save as box so that I can save the current sheet before it gets reset, that all is working fine.
    The problem that I have is, when i go back to the folder where I saved the sheet they are not there and there for I dont have a copy saved and if I dont print it prior I have to do it all over again.

    The code im using is listed below.

    Thanks Michael
    Please Login or Register  to view this content.
    Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #3 requires code tags. I have added them for you this time for the sake of moving forward, but please do this in your next post. --6StringJazzer
    Last edited by 6StringJazzer; 09-12-2018 at 08:31 PM. Reason: code tags

  2. #2
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,004

    Re: Reset Button

    .
    Paste this macro into a Routine Module :

    Please Login or Register  to view this content.
    Paste this macro in the Sheet1 Module :

    Please Login or Register  to view this content.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Create running stopwatch/timer with 1 button (start/stop). No reset button.
    By leeroy2612 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-26-2021, 12:59 AM
  2. Reset Button
    By simonplus in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-26-2017, 12:33 PM
  3. [SOLVED] I need to create a reset button that will reset rows containing a specific value
    By odin78 in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 04-03-2016, 02:11 PM
  4. VBA as a reset button
    By tantcu in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-10-2013, 12:39 AM
  5. Reset Button
    By alvstar2001 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-22-2013, 06:03 AM
  6. Reset Button??
    By elfiky in forum Excel General
    Replies: 2
    Last Post: 03-19-2009, 09:05 PM
  7. Reset Button
    By va33eric in forum Excel General
    Replies: 4
    Last Post: 07-16-2008, 10:52 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