Sheet Tab hide with a Password or Macro

Hi Friends!!

I want to hide sheet tab with and lock it with password..!

I know, how to hide it from Excel Options --> Advance --> Show Sheet Tab, but if users of my sheet are good on excel they can view my sheet tab by unchecking the show sheet tab.

I want to hide it with a password or macro..

Please help me!!!
abamasd

Use the code:

Please Login or Register  to view this content.

And, password protect the VBA Project.

--Karan--

Hi Friends,

How can I hide sheet tab not the sheets..! only the sheet tab with password or marcro please help me...!

I know how to protect sheet tab from EXCEL OPTIONS>ADVANCE>SHOW SHEET TAB uncheck.

its easy for user to view all my sheets..!

Please help me!!
Abamasd

As far as I am aware you can only show/hide all of the tabs in a workbook.

The code to do this is

Please Login or Register  to view this content.

You could put this in the workbook open event, but what you would achieve I don't really know.
This can be over ruled by the user changing the options.

Navigation through the sheets would then have to be done with another macro on the lines of, or at least containing for example

Please Login or Register  to view this content.

This could then be protected.
If you think that this is an option let me know and I will give it a go.

However if I am reading you correctly, you only want to hide some tabs, I don't think it is possible.

Others might know better and I will stand corrected.

Marcol,

You are right, i want to show/hide all of the tabs in a workbook.

Code given by you: "ActiveWindow.DisplayWorkbookTabs = False" will it work to hide/show all the tabs in a workbook if yes.

Please let me know the complete proceedure to write this code.

Should I write this code on each sheet? if not, please send me an excel sheet with an example.

Thanks for your help.
Abamasd

It depends on where you want to trigger the code, have a look at this thread and see if it helps.

http://www.excelforum.com/excel-prog...ml#post2314145

This shows how to hide the tabs if only one sheet is visible, you should be able to then use a password somewhere to protect the code.

If you don't find this thread useful, post a sample workbook explaining, how you would like it to work.
There are to many possiblities to guess what suits you best.

Cheers

It might be your solution to do something like this in the Workbook Module

Please Login or Register  to view this content.

Where Sheet1 is the sheet you want to be displayed.

If the user resets the Option Sheet Tabs, the code will trigger when the user selects any sheet other than the one you one you want them to see, and return them to your selected sheet.

Password protect the vba project, so that they cannot alter the code.

Hope this helps

Hi Marcol,

this codes not helpfull for me. I just wanted to HIDE SHEETs TAB. and protect it with a password.
I dont want to hide any sheet in workbook. just want to hide sheets tab. thats it.

Please help me.
Abamasd

Hi friends,

Please refer to my attached sheet..!

Hi,

please refer to this sheet...!

Try this

In the workbook module

Please Login or Register  to view this content.

Uncheck the tab option, then try to select another sheet.

You could also password protect the vba project, to be double sure, no unauthorized person can find the password.

Hope this helps.

If you need any further information, please feel free to ask further

However

If this takes care of your needs, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED. It helps everybody!
Also
If you are satisfied by any members response to your problem please consider using the scales icon top right of thier post to show your appreciation.

Marcol,

I really appreciate your all hardwork!!!

Its realy nice work.

But, its not allowing me to move from one sheet to another. Actually i wanted to protect sheets tab with a password.

And i want user to use the buttons or hyperlinks to move from one sheet to another..! I dont want to show all my sheets to the user in sheets tab.

I believe, if you modify your codes, it can be done..

I really appriciate!! your all hard works and help..!

Please refer to attache sheet mac33

Thanks,
Abamasd

Marcol,

My Dear Friend,

Its not working : (, i just want to hide sheet tab and want move from one sheet to another through buttons or hyperlinks..! just dont want show sheets tabs to users..! as how many sheets are there in that workbook.! but he can visit to any site through hyperlinks or buttons with a small marco..!

or please send me an example in an excel sheet..

WIll be waiting for ur reply.

please help me
Abamasd.

Hi Abamasd

Looks like I failed to attach the amended file to Post #14, don't know why.

Rather than post it all again I have edited the post and added the relevant file.
Please look at the amended post.

Sorry about that.

If Anyone uses excel 2007 , If they go to excel options and tick the check box to show sheet tabs, This macro has no use. I have the same trouble. How to prevent users changing my macro from EXCEL OPTIONS

Originally Posted by abamasd

Marcol,

I really appreciate your all hardwork!!!

Its realy nice work.

But, its not allowing me to move from one sheet to another. Actually i wanted to protect sheets tab with a password.

And i want user to use the buttons or hyperlinks to move from one sheet to another..! I dont want to show all my sheets to the user in sheets tab.

I believe, if you modify your codes, it can be done..

I really appriciate!! your all hard works and help..!

Please refer to attache sheet mac33

Thanks,
Abamasd

thanks arul, i'll do it . i am new to this forum