Results 1 to 8 of 8

VB Code .xlsm file with automatically hide and unhide sheet entities option

Threaded View

Sekars VB Code .xlsm file with... 11-27-2019, 11:32 PM
Pepe Le Mokko Re: VB Code .xlsm file with... 11-28-2019, 04:00 AM
madhumadhan Re: VB Code .xlsm file with... 11-28-2019, 04:35 AM
Sekars Re: VB Code .xlsm file with... 11-28-2019, 06:33 AM
madhumadhan Re: VB Code .xlsm file with... 11-28-2019, 07:04 AM
Sekars Re: VB Code .xlsm file with... 11-28-2019, 07:17 AM
madhumadhan Re: VB Code .xlsm file with... 11-28-2019, 07:29 AM
Sekars Re: VB Code .xlsm file with... 11-28-2019, 07:54 AM
  1. #1
    Forum Contributor
    Join Date
    02-15-2016
    Location
    India
    MS-Off Ver
    2016
    Posts
    671

    VB Code .xlsm file with automatically hide and unhide sheet entities option

    Hello

    I need to provide extra security to a password locked file. For this I have a suggestion with Password locked VBA macro code for Sheet named say `SheetX’. In `SheetX’ in particular cell say `X500’ if some particular text say `ABC1234XYZ’ is there then all should be visible in the `SheetX’, if no text `ABC1234XYZ’ is there in cell `X500’ of `SheetX’ then all (Texts and Formats) should be hided in `SheetX’.

    Also if saved, closed and re-opened the file then the macro should automatically clear the entry of `ABC1234XYZ’ is there in cell `X500’ of `SheetX’.

    So the inputs in password locked macro will be
    Sheet name : Say `SheetX’*
    Cell # in `SheetX’ : `X500’
    Text in Cell X500 : `ABC1234XYZ’
    Password for vbcode : `ABCD@1234’
    All these above 4 inputs should be entered only one time in VB Code and it should not prompt to enter when opening .xlsm excel file every time. Except password which needs to be prompt for enter when vb code required to change.

    Thanks in advance

    Sekar
    Attached Files Attached Files
    Last edited by Sekars; 11-28-2019 at 01:31 AM. Reason: Adding Attachments
    Sekar

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Hide/Unhide Command Button with save file option
    By eltigre in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-10-2017, 03:52 AM
  2. Vb code to hide/unhide rows based on entries on another sheet
    By tcrjmom in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-24-2015, 01:15 PM
  3. [SOLVED] Need Option Button To Hide Or Unhide Worksheets
    By HaroonSid in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 03-13-2014, 12:03 AM
  4. Replies: 3
    Last Post: 05-21-2013, 08:22 AM
  5. Protect the Hide/Unhide option
    By Bestycame in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-06-2011, 01:48 PM
  6. Hide row if cell is a certain value, with unhide toggle option
    By stir-crazy in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-16-2008, 09:16 PM
  7. Hide/Unhide Option - Need to consider all options!
    By Turquoise_dax in forum Excel General
    Replies: 3
    Last Post: 06-15-2006, 04:17 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