Prevent User from unhiding sheet

[vandanavai]

Hello,

I have workbook with 3 sheets. User is required to enter data by using 'User Form' designed for the same. Entered data is transferred to sheet 'Data' which is hidden sheet. I don't want user to unhide sheet 'Data' and make any changes. User can always unhide sheet by using menu Format-sheet-unhide.
How to prevent user from unhiding sheet?

Please help me.

[jasoncw]

In VBA, you can use the following:

Please Login or Register  to view this content.

This will allow only VBA to unhide the sheet.

[vandanavai]

Thanks jasoncw. It worked in manner I wanted. If password can be added in this code so that only one who know password can unhide sheet?

[jasoncw]

Since the only way to unhide is via VBA, then you can protect your VBA project. With the file open, go to the VBE, then Tools > Properties. On the protection tab, check the box and add a password.

[Imrana]

Since the only way to unhide is via VBA, then you can protect your VBA project. With the file open, go to the VBE, then Tools > Properties. On the protection tab, check the box and add a password.

Hi, it is unfortunately very easy to change visibility simply by pressing ALT+F11 and changing the Visibility property from "xlVeryHidden" to "xlSheetVisible". However it's true that adding a password to VBA prevents anybody who does not have the pwd to change the visibility.

My concern however is about Activation of Macros and VB code.
If a user has configured his excel to DISABLE Macros and VB, xml etc. then probably the VB code below will not run while sitting in section WorkBook_Open (runs when workbook opens) ??
Or will it still run and hide the wanted sheets/Tabs ?

Please Login or Register  to view this content.

[mc84excel]

My concern however is about Activation of Macros and VB code.
If a user has configured his excel to DISABLE Macros and VB, xml etc. then probably the VB code below will not run while sitting in section WorkBook_Open (runs when workbook opens) ??
Or will it still run and hide the wanted sheets/Tabs ?

If an Excel user opens a workbook without enabling macros, no code runs. This includes event procedures such as Workbook_Open

The solution to this problem is to use code so that the workbook is unusable unless the user enables macros. i.e. FORCE users to enable macros.

Multiple versions of 'Force Enable Macros' code exists (google). Here's one: http://xl-central.com/force-users-to...-workbook.html

Obviously you would need to edit this code so that the sheets you wish to keep veryhidden are not made visible once the user enables macros. HTH

[HaHoBe]

Hi, Imrana,

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.

Ciao,
Holger