How to edit, hide and protect a single sheet whilst also keeping other sheets hidden and protected

 Question:

 

Thanks for taking a look at this question, I can't seem to find a solution that fits my needs.
I have a spreadsheet that has many individual sheets (sheet1,sheet2,sheet3...sheetx).
Sheet1 must always be visible.
Sheets 3,4,5....x must be hidden and protected such that they cannot be unhidden without unprotecting the workbook.
Sheet 2 must be normally hidden and protected as above but with the option of editing it after entering a password. The process of hiding and unhiding this sheet must not allow the user to see or unhide sheets 3,4,5....x
i.e the user must be able to hide,unhide and edit sheet 2 by use of a password but without ever allowing the user to see sheets 3,4,5,x etc.
Thanks again for having a look at this. Charlie




 Answers:
 


You can try hiding sheet 2 (right click --> hide) and then password protecting the workbook.
But before that go to VBA and paste and run this:
Sub HideSheets
    Worksheets("sheet3namehere").Visible =xlVeryHidden
    Worksheets("sheet4namehere").Visible =xlVeryHidden
    Worksheets("sheet5namehere").Visible =xlVeryHidden
End Sub
Doing this will remove the Unhide option for the above sheets from the user interface.
To unhide the sheets you will have to repeat the above but change xlVeryHidden to True.
Lastly you can password protect your vba project: Tools --> VBA Project Properties--> Protection. You can use a different password from the one that you have used for the workbook.
This way the needed sheets can be hidden without the Unhide option from the menu. While sheet2 can be still unhidden in the normal way if the user has the password to unprotect the workbook.

Commentaires

Enregistrer un commentaire

Posts les plus consultés de ce blog

XAJAX with PHP – The future of web development

XAJAX is a class library or framework written purely on PHP that allows you to easily create powerful, Web-based, Ajax applications or plugins. You can download xajax framework from http://sourceforge.net/projects/xajax/ XAJAX is easy to impement. You need to just include XAJAX library, instantiate the xajax object, and register the name of function (or an object or class method) which you want to call from XAJAX framework. xajaxResponse() is an object to return the results of our requests as XML formats. Then call that particular function you want from xajax framework through your HTML or javascript. That's it. XAJAX takes care of most everything else. You just need to write the PHP functions and returning XAJAX XML responses from them, which is made extremely easy by the xajaxResponse class. Code: <?php include './xajax/xajax_core/xajax.inc.php'; $xajax = new xajax(); $rqstAdd =& $xajax->register(XAJAX_FUNCTION, 'ad...
Lire la suite

XAJAX with PHP – The future of web development

XAJAX is a class library or framework written purely on PHP that allows you to easily create powerful, Web-based, Ajax applications or plugins. You can download xajax framework from http://sourceforge.net/projects/xajax/ XAJAX is easy to impement. You need to just include XAJAX library, instantiate the xajax object, and register the name of function (or an object or class method) which you want to call from XAJAX framework. xajaxResponse() is an object to return the results of our requests as XML formats. Then call that particular function you want from xajax framework through your HTML or javascript. That's it. XAJAX takes care of most everything else. You just need to write the PHP functions and returning XAJAX XML responses from them, which is made extremely easy by the xajaxResponse class. Code: <?php include './xajax/xajax_core/xajax.inc.php'; $xajax = new xajax(); $rqstAdd =& $xajax->register(XAJAX_FUNCTION, 'a...
Lire la suite

Database connection pooling in ADO.Net

Imagine a situation that multiple users are connecting the same database through our application. In an application establishing a database connection and logging into it is a time consuming activity. It needs several seconds for every time it establishes a connection. So opening and maintaining a database connection for each user is not an ideal solution. When the number of users increases, and if the system�s memory set is limit, probably it leads to a system crash. This problem can solve through connection pooling. A connection pool is a cache or pool of database connections maintained by the application so that the connections can be reused when the database receives future requests for data. Establishing once and reserving it for future request can essentially improve the overall performance of the application. In connection pooling, after a connection is created, the connection object is placed in the pool. When a simultaneous connection request is made later, ...
Lire la suite