+ Reply to Thread
Results 1 to 2 of 2

command button to Save As sheet in new workook and Close options to hide sheet

  1. #1
    Registered User
    Join Date
    10-30-2018
    Location
    Sydney
    MS-Off Ver
    Offic 365
    Posts
    5

    command button to Save As sheet in new workook and Close options to hide sheet

    Hi there,

    I am working on a document that has will enable hiring managers to access recruitment tools when conducting interviews.

    Within the main page of the document (tab titled “Interview Type”), managers can check a box to auto populate a form with pre-defined questions. When you check the box it will unhide the relevant question set in a new tab.
    What I am then looking at doing is including 2 command boxes to:

    •either save as the new tab (sheet) into a new workbook (i don't need a preferred file name to establish - as manager to save to appropriate folder) or
    •go back to main tab (Interview type) with an auto uncheck of the box to hide the tab just opened.

    I have included a sample document with instructions to hopefully expand on this a little better.

    If you need anything else, let me know.

    Cheers .... Amanda

  2. #2
    Registered User
    Join Date
    10-30-2018
    Location
    Sydney
    MS-Off Ver
    Offic 365
    Posts
    5

    UPDATED command button to Save As sheet in new workook

    I have managed to work out majority of the coding needed, however I am still having issues with the SaveAs function.

    How do I save a single worksheet to a new workbook as an xls document (as I don't need the macro)? The issue I will be facing is that the worksheets will have different names, so would this work as ActiveWorkSheet?

    Also, I don't want a specified file path or name as I want the person using the document to save to their own file path and title as they need to.

    Ideally, I would like the person using the form to click on the SaveAs form button, it create the sheet in a new workbook, the SaveAs box come up, and then the file to be renamed and saved as needed.

    Any help would be greatly appreciated. I have updated the document.

    Cheers ... AM
    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. [SOLVED] Hide command button, based on cell value when linked to another sheet?
    By npsnps in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-19-2017, 08:21 AM
  2. Open/Save/Close Workbook via command button
    By nathan0519 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-31-2015, 11:24 PM
  3. [SOLVED] Need Help With Coding Command Button to Close Sheet Text Box
    By mandora in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-08-2014, 04:39 PM
  4. Save multiple sheet/print sheet with one command button
    By GJR in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-23-2014, 03:06 PM
  5. Command Button - Hide and Unhide Sheet VBA
    By Kimber20 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 03-09-2014, 11:06 AM
  6. [SOLVED] command button: specified sheet copy and save as new workbook to specified location
    By Zlatko.Pan in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-15-2013, 12:28 PM
  7. Replies: 1
    Last Post: 12-13-2012, 07:27 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