+ Reply to Thread
Results 1 to 4 of 4

assistance to amend code for a closed workbook to remain close when macro runs

  1. #1
    Forum Contributor
    Join Date
    02-11-2014
    Location
    mauritius
    MS-Off Ver
    MS365
    Posts
    1,086

    assistance to amend code for a closed workbook to remain close when macro runs

    Hi All

    I used this code on active sheet to copy from closed workbook and insert the format in active workbook but I noticed that sheet WORKINGS from closed workbook in C:\\ opens also. I need to closed it manually.

    looking a way that the closed workbook to remain close when macro runs


    Please Login or Register  to view this content.

  2. #2
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,262

    Re: assistance to amend code for a closed workbook to remain close when macro runs

    What about changing
    Please Login or Register  to view this content.
    Good Luck
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the star to left of post [Add Reputation]
    Also....add a comment if you like!!!!
    And remember...Mark Thread as Solved.
    Excel Forum Rocks!!!

  3. #3
    Forum Contributor
    Join Date
    02-11-2014
    Location
    mauritius
    MS-Off Ver
    MS365
    Posts
    1,086

    Re: assistance to amend code for a closed workbook to remain close when macro runs

    thank you for assistance

    I made changes as It was asking to save


    Please Login or Register  to view this content.

  4. #4
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,262

    Re: assistance to amend code for a closed workbook to remain close when macro runs

    Cool...Thanks for rep points

+ 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] VBA runs if workbook is open or closed
    By namluke in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-29-2014, 07:14 PM
  2. Ghost project remain in VB Editor after Workbook is closed
    By Kiwoop in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-31-2013, 05:03 AM
  3. VBA Project and Modules Remain in Project Explorer after workbook closed
    By avr5iron in forum Excel Programming / VBA / Macros
    Replies: 26
    Last Post: 03-09-2012, 11:38 AM
  4. General Info needed for reading/writing data to a workbook that can remain closed.
    By garden_gnome in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-08-2012, 10:21 PM
  5. Macro runs on wrong workbook on close
    By Cumberland in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 07-30-2009, 07:47 AM
  6. worksheet combo box code runs when workbook open and close
    By hilander in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 11-29-2008, 10:25 PM
  7. VBAProjects remain in memory after workbook is closed
    By Arif Ali in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 08-08-2006, 10:40 AM
  8. Macro code to open a workbook only when closed
    By Jeff in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-16-2006, 04:25 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