+ Reply to Thread
Results 1 to 3 of 3

Hide the Sheet As per the System User Name

  1. #1
    Forum Contributor
    Join Date
    11-26-2013
    Location
    India
    MS-Off Ver
    2010
    Posts
    157

    Hide the Sheet As per the System User Name

    Dear Team,

    I have a challenge in excel functions, I need to save a file as common folder but in that workbook have multiple sheets need to show the sheets as per the user name on system other sheets want to hide with password protect,

    example,

    file name:- Report
    Sheets:- A,B,C,D
    if now using system user name is A then need to show only "A" sheet, other sheets want to be hide and the same for all.........

    thanks

    Liju M

  2. #2
    Valued Forum Contributor
    Join Date
    02-05-2013
    Location
    Jakarta, Indonesia
    MS-Off Ver
    Excel 2013
    Posts
    571

    Re: Hide the Sheet As per the System User Name

    I think no excel function that can hide sheet instead you need macro for this.

    I can only suggest you to read this:
    http://stackoverflow.com/questions/6...name-in-a-cell
    http://stackoverflow.com/questions/1...t-using-macros
    http://www.techrepublic.com/blog/mic...xcel-workbook/
    Click (*) if you received helpful response.

    Regards,
    David

  3. #3
    Forum Contributor
    Join Date
    11-26-2013
    Location
    India
    MS-Off Ver
    2010
    Posts
    157

    Re: Hide the Sheet As per the System User Name

    Thanks,

    Dear SDCh their is no what i actual required .....


    Thanks
    Liju M

+ 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. make user form stay open while going to other pages but hide when i go to other sheet
    By excelslizzard in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-18-2012, 07:12 PM
  2. USER FORMS NOT WORK AT SYSTEM 32 Bits AND SYSTEM 64Bits
    By Flash_Azul in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-16-2011, 08:02 PM
  3. USER FORMS NOT WORK AT SYSTEM 32 Bits AND SYSTEM 64Bits
    By Flash_Azul in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-09-2011, 03:16 AM
  4. [SOLVED] User Access to System
    By Sgwapt in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-24-2005, 02:05 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