•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the VB.NET section within the Software Development category of DaniWeb, a massive community of 402,549 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,278 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our VB.NET advertiser: Programming Forums
Views: 14368 | Replies: 1
![]() |
Hello,
This might be in the wrong place. My question pertains to MS Excel, and using Visual Basic for Applications (VBA).
We have a user that would like to hide one of her worksheets within a workbook. She would like the sheet to be securely hidden.
I found this piece of code:
and the sheet does disappear.
There are two problems:
1) I don't like the Macro warning. Hints that something might be up, and if they disable the macros, then this visibility thing does not work.
2) Anyone can go into the Visual Basic for Applications menu, and see all of the worksheets in broad daylight. They can highlight the hidden sheet, and go to the properties, and unhide it with their mouse. Data revealed.
I am going to discuss with the user the wisdom of trying to do this. If she wants to go ahead though, and do "security through obscurity", then that is her call. What I want to be sure of though is that there isn't any other way to place a password on the VBA menu, or perhaps prevent the sheets from displaying on the VBA menu.
If anyone has ideas, please let me know. I am not very proficient in VBA, so please spell out the steps taken.
Thanks,
Christian
This might be in the wrong place. My question pertains to MS Excel, and using Visual Basic for Applications (VBA).
We have a user that would like to hide one of her worksheets within a workbook. She would like the sheet to be securely hidden.
I found this piece of code:
Sub HideSheet()
Sheets("Sheet2").Visible = xlVeryHidden
End Sub and the sheet does disappear.
There are two problems:
1) I don't like the Macro warning. Hints that something might be up, and if they disable the macros, then this visibility thing does not work.
2) Anyone can go into the Visual Basic for Applications menu, and see all of the worksheets in broad daylight. They can highlight the hidden sheet, and go to the properties, and unhide it with their mouse. Data revealed.
I am going to discuss with the user the wisdom of trying to do this. If she wants to go ahead though, and do "security through obscurity", then that is her call. What I want to be sure of though is that there isn't any other way to place a password on the VBA menu, or perhaps prevent the sheets from displaying on the VBA menu.
If anyone has ideas, please let me know. I am not very proficient in VBA, so please spell out the steps taken.
Thanks,
Christian
•
•
Join Date: Jul 2004
Location: Adelaide, Australia
Posts: 191
Reputation:
Rep Power: 5
Solved Threads: 1
•
•
•
•
Originally Posted by kc0arf
Hello,
This might be in the wrong place. My question pertains to MS Excel, and using Visual Basic for Applications (VBA).
We have a user that would like to hide one of her worksheets within a workbook. She would like the sheet to be securely hidden.
I found this piece of code:
Sub HideSheet() Sheets("Sheet2").Visible = xlVeryHidden End Sub
and the sheet does disappear.
There are two problems:
1) I don't like the Macro warning. Hints that something might be up, and if they disable the macros, then this visibility thing does not work.
2) Anyone can go into the Visual Basic for Applications menu, and see all of the worksheets in broad daylight. They can highlight the hidden sheet, and go to the properties, and unhide it with their mouse. Data revealed.
I am going to discuss with the user the wisdom of trying to do this. If she wants to go ahead though, and do "security through obscurity", then that is her call. What I want to be sure of though is that there isn't any other way to place a password on the VBA menu, or perhaps prevent the sheets from displaying on the VBA menu.
If anyone has ideas, please let me know. I am not very proficient in VBA, so please spell out the steps taken.
Thanks,
Christian
You cannot disable the macro warning with a macro. No way around it, after all if there was then there would be no point it being there.
Second question, you can password protect your vba project so even if someone does go the the vba menu they will not see the modules or worksheets. Look under Tools->VBA Project properties from the VBA window.
Thirdly the code you've written above only needs to be used once. Why not set the worksheet to xlVeryHidden before you distribute it? You don't need to hide it every time you open the file. Once you've set it to xlVeryHidden and saved the file it's 'very hidden' until someone else makes it visible from another bit of vba code.
Hope that helps.
Mark Nemtsas
Time and Billing Software - Time Tracking Software - Roller Shutters - Roller Blinds -
Baby Books
Time and Billing Software - Time Tracking Software - Roller Shutters - Roller Blinds -
Baby Books
![]() |
•
•
•
•
•
•
•
•
DaniWeb VB.NET Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
•
•
•
•
.net .net framework 3.0 access api asm assembly x86 programming hla demo asp blogger blogging c c++ ccna code coding combo competition compiler computer custom data developer development dropdownlist evaluation gdata google high-performance java mcse microsoft microsystems module net networking object online planning platform practices programming python reuse rss skin software sun theme tools tutorials web xml
- Anything and Everything (Geeks' Lounge)
- Getting started programming Windows (C++)
- Tell us about yourself! (Community Introductions)
- Microsoft Excel Programming problem (Windows Software)
- Suggestions on what type of programming language would be best for the situation (Computer Science and Software Design)
- What Language is used in software like Adobe Photoshop? (C++)
Other Threads in the VB.NET Forum
- Previous Thread: How to sort the rows in the datagrid and update it successfully?
- Next Thread: Need Help With two-dimensional array



Linear Mode