+ 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
    2007
    Posts
    3,640

    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
    DEPLORABLE : A hard working, tax paying, patriotic American. That's me !

    Cats. Because People Suck.

    If someone has assisted you in any way, please be respectful to acknowledge it.
    Simply saying "Thank you" will suffice. If you are so moved, adding to their reputation by clicking
    <------ Add Reputation is a very nice gesture.
    When your question has been answered, Please mark the thread as SOLVED.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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