Hide and Unhide one sheet
Hello again,
I am trying to hide one sheet and range of rows when it is not activate. Untill the password enter correct the rows should be hidden.
but the script is giving error. Can some one help to fix this issue please.
Copy of the fine as an sample is attached.
Please Login or Register to view this content.
Last edited by hecgroups; 03-17-2012 at 01:30 PM. Reason: Updated file is attached below
Can someone help me please anyone
hi,
I am sorry, I think it's confusing for me, would you want to tell us what you are trying to achieve?
when you open the workbook, what do you want to have?
and who is "Call CreateMeniu"?
Regards, John55
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
...enjoy -funny parrots-
Sorry just omit this call create menu.
What i want here is the following.
1. I want to restrict users to use the rows from 12 to 64. Only Admin who enter the password can view the rows.
2. If the admin use the files then if he click the other sheets i.e.Data or Template the Sheet1 will hide the rows 12:64 and hide the sheet1.
3. When the admin click on Loading macros to view rows he has to enter the password.
Everything is going fine accept this hiding rows and hiding sheet1
Updated file is attached for your reference.
hi,
try this...
Please Login or Register to view this content.
This is what i am trying to do but when i go back to the sheet the rows are viable which should not be.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks