+ Reply to Thread
Results 1 to 2 of 2

open userfrom only without excel sheet and when close userform close excel file completey

  1. #1
    Forum Contributor
    Join Date
    11-28-2013
    Location
    Ljubljana
    MS-Off Ver
    Office 365
    Posts
    1,054

    open userfrom only without excel sheet and when close userform close excel file completey

    Dear Expert
    i want to do the following
    when i open my file it just open userform only without sheet in my file that allow user for add data in userfrom
    then
    when they try to close userfrom they will close all excel workbook completety
    here i find this code but its work good when open file but after i add my data its show all my sheet
    HTML Code: 

  2. #2
    Forum Contributor
    Join Date
    11-28-2013
    Location
    Ljubljana
    MS-Off Ver
    Office 365
    Posts
    1,054

    Re: open userfrom only without excel sheet and when close userform close excel file comple

    the problem exactly after i press button with the following code
    HTML Code: 
    after i press this button for this code its show sheet
    can i add to this code something not allow to show the code plus the code in post 1 that i put in thisworkbook

+ 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. Replies: 7
    Last Post: 02-06-2015, 04:13 PM
  2. efficiently open and close an Excel file in VBA Access
    By ucalcen in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-07-2014, 05:47 PM
  3. Open excel file read the data and close
    By girish1989 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-04-2013, 10:09 AM
  4. Check if a Word File is Open and If Open Close it with Excel VBA.
    By e4excel in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-10-2012, 11:14 AM
  5. Need Help with Excel Macro - Open - Close File
    By Lpitt56 in forum Excel General
    Replies: 6
    Last Post: 01-26-2012, 03:31 PM
  6. Close an Excel file if is found it open.
    By maperalia in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 05-07-2006, 06:42 AM
  7. Macro to open and close an Excel file
    By Magnivy in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-13-2006, 11:35 AM
  8. [SOLVED] Delete/Close Excel file that is kept OPEN
    By Jafer in forum Excel - New Users/Basics
    Replies: 0
    Last Post: 04-15-2005, 01:06 AM

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