+ 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,990

    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)

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