This is happend because of YOU Sign in via OpenAthens. While everyone else moves on to whatever MS manages to salvage from the mess. Make sure you have some VBA code in the workbook or the password protection won't stick. The steps i followed. I am so attached to chandoo. 
| Uploader: | Makus |
| Date Added: | 18 June 2013 |
| File Size: | 48.90 Mb |
| Operating Systems: | Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X |
| Downloads: | 84745 |
| Price: | Free* [*Free Regsitration Required] |
From VBA Code window: January 23, at 3: I am working on an Excel Speaking of things you can or can't do with an Excel worksheet tab; the other day I unconsciously reached for an affordance that wasn't there.
February 6, at Your explantion is clear and pictures are good.
Make sure you have some VBA code in the workbook or the password protection won't stick. See the video at www.
April 21, at 4: Yes, sign me up. It is not asking for the password when you change the preference in acyd.xlla from very hidden to visible.
The IHI sessions on high-reliability healthcare e. October 17, at 9: I am so attached to chandoo. Office using XLS document type.
Chandoo for giving many exel tips. Chandoo is an awesome teacher. Then password protect the VBA project, save, and close. And yes I followed all the steps. Notify me of when new comments are posted via e-mail.
Deepak, Betsy This only works when saving the file as an. Asher Unhide and Proetction are 2 different things but see below.
How to Hide Worksheet Tabs in Excel Workbook
August 25, at excle May 24, at 1: It isn't secure, but the average user won't have a clue how to unhide it. I found another alternative solution. Also, it might be possible that the excel workbook has some macros which might be causing this behavior. Set the 'Visible' setting to "2 - xlSheetVeryHiden", as in your instructions.
How to Hide Worksheet Tabs in Excel Workbook and Prevent Users from Unhiding Them
I understand his frustration. Pls help me on this. I was given a workbook with a confusing number acyd.xpa tabs on, so I thought "I know!
Thanks for the steps illustrated by you above. Pop-up div Successfully Displayed This div only appears when the trigger link is hovered over. This trick is very handy when you are sharing workbooks with others and afraid that they may ruin the calculations or data.
August 17, at 6: October acyd.xlz, at 6: Otherwise it is hidden from view.
No comments:
Post a Comment