Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to hide sheets and VBA code in my Excel workbook?
Hi,
As far as I know, there is no code in Excel that is secure, even with passwords. There's always someone selling password cracking software. You might be able to write this Excel VBA code in VB6, and give to your client an executable program that can't be cracked. I'm not sure if it would work in your case, but you might want to investigate this some more. I'm new at writing Excel VBA code this way in VB6. I've got some simple programs to work and they work perfectly. If you need more specific questions, I hope one of the experts with this type of programming can help. Rick -----Original Message----- Hello! I write VBA code to automate certain functions in my Excel file, and I use a lot of "template" sheets to generate charts and save them as a new xls file. My client wants to run my programs on their site, which requires that I give them a copy of the main Excel workbook that contains my templates and VBA code. Is there any way for me to hide them so that my client cannot copy my code? Ideally, I want to be able to password-protect everything in my file. (The client really just has to press the keyboard shortcut --- CTRL-M --- to run my main routine.). Thanks for your help. Greg . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Code to hide sheets | Excel Worksheet Functions | |||
how do I hide scroll bars on specific sheets within a workbook | Excel Discussion (Misc queries) | |||
How to hide VB code from Excel file | Setting up and Configuration of Excel | |||
How to repeat a code for selected sheets (or a contiguous range of sheets) in a Workbook? | Excel Worksheet Functions | |||
VBA Code To have a macro repeat on all sheets in a workbook | Excel Worksheet Functions |