Results 1 to 18 of 18

xlSheetVeryHidden Not Working At all

Threaded View

  1. #16
    Forum Contributor
    Join Date
    05-14-2011
    Location
    London, England
    MS-Off Ver
    Excel 2003, 2007, 2010
    Posts
    120

    Re: xlSheetVeryHidden Not Working At all

    Hi Winon,

    I am sorry, please, that I am coming back to you, two days late, with this feedback. My health was a bit poorly, but I am feeling a bit better now.

    You are really a genius!

    Thanks very much for the amended codes. The file now exits completely with each of the exit buttons.

    There is only one little final adjustment, please, that I'll like you to kindly do for me. When the Exit button on 'Sheet3' i.e. the Macro Enabling instruction sheet is clicked, the file closes OK. And when you start the application again, the first sheet that comes up is the Sheet3 (i.e. Macro-enabling instruction sheet). This is Perfect!

    However, when you click the Exit button on the Main Office sheet, and start the application again, the first sheet that comes up is the Main Office sheet instead of the Sheet3 (the Macro-enabling instruction sheet). Please this is the only final adjustment i.e. When a user exits the application using the Main Office 'Exit' button, and then restarts the application, the user should be taken to Sheet3 (the Macro enabling instruction sheet) and not straight to the Main Office sheet.

    Again, thank you Winon for all your kindness and support. You have been wonderfully helpful.

    Buddy
    Last edited by Buddy8; 05-29-2016 at 06:01 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. xlSheetVeryHidden Module
    By pmakulski in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-19-2015, 01:25 PM
  2. NEED HELP PLEASE!! VBA code to xlSheetVeryHidden
    By lester.ilao in forum Excel General
    Replies: 3
    Last Post: 10-28-2014, 10:14 PM
  3. XlSheetVeryHidden code before close (Method Error)
    By ron2k_1 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-10-2012, 12:27 PM
  4. Problems with XLSheetVeryHidden
    By alderran in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-28-2007, 05:58 AM
  5. worksheets xlSheetVeryHidden and show them once password-app
    By Param in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-26-2006, 09:00 PM
  6. Trouble with copy of xlSheetVeryHidden
    By Casey in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-14-2005, 10:05 PM
  7. [SOLVED] Opeations on xlSheetVeryHidden worksheet
    By Frederick Chow in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-10-2005, 03:06 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