+ Reply to Thread
Results 1 to 2 of 2

Unhidden sheet in signed excel

  1. #1
    Registered User
    Join Date
    08-11-2020
    Location
    Poland
    MS-Off Ver
    2016
    Posts
    4

    Unhidden sheet in signed excel

    Hello fellas. My first question here is : Does exist any solution to unhide very hidden sheet in digital signed workbook? Take a look at this flow : user 1 logged into workbook - signed file - save and close. - admin logged into workbook with extra privileges (for this user exist 1 extra sheet which is unhiden automatically when admin is logged) - sheet is still hidden.

    Help please?

  2. #2
    Forum Expert
    Join Date
    07-06-2004
    Location
    Northern California
    MS-Off Ver
    2K, 2003, 2010, O365
    Posts
    1,490

    Re: Unhidden sheet in signed excel

    Are you using a VBA procedure to unhide the worksheet which should be visible for the admin? How are you checking the admin user's user ID?

    In general, in a workbook open in Excel, a very hidden worksheet can be made visible using

    Please Login or Register  to view this content.
    in a VBA procedure. In this case, it'd seem the best place for this would be in the Workbook.Open event handler after confirming that the user ID is that of the admin. Obviously you'd need to change WorksheetName to the name of your worksheet you want to make visible.

+ 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. request password when clicking on visible/unhidden excel sheet/tab
    By deanusa in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-29-2016, 11:16 AM
  2. [SOLVED] Button to show unhidden sheet with set rown
    By ramatthews in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-18-2015, 03:01 PM
  3. How to copy a sheet from hidden to unhidden
    By ronkruyt in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-02-2013, 05:41 AM
  4. [SOLVED] Move to next or previous unhidden sheet
    By ddgacic in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-01-2012, 04:16 AM
  5. [SOLVED] Move to next or previous unhidden sheet
    By ddgacic in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-30-2012, 04:56 AM
  6. [SOLVED] Working Age Group Signed From DOB and Date Signed
    By Bellio3105 in forum Excel General
    Replies: 2
    Last Post: 11-05-2012, 02:02 PM
  7. How to run a macro 30 seconds after sheet is unhidden
    By CRIMEDOG in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-15-2011, 12:04 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