Actuarial Outpost
 
Go Back   Actuarial Outpost > Actuarial Discussion Forum > Software & Technology
FlashChat Actuarial Discussion Preliminary Exams CAS/SOA Exams Cyberchat Around the World Suggestions


Reply
 
Thread Tools Search this Thread Display Modes
  #11  
Old 06-07-2019, 10:47 AM
Bicycle Repair Man's Avatar
Bicycle Repair Man Bicycle Repair Man is online now
Member
 
Join Date: Nov 2003
Posts: 14,264
Default

Quote:
Originally Posted by BruteForce View Post
You can password protect the VBA (In the VBA editor: Tools -> VBAProject Properties -> Protection). That will make it so that no one without the password could open up your file and see the worksheets or VBA code (there are ways around it, but I'm assuming your kids aren't going to be sitting at the computer for 20 minutes without you noticing them).

You can password protect just a worksheet (In my version of Excel: Review -> Protect Sheet). In you're macro you'll just have to add a worksheet.unprotect "password" to your code before you do any edits, then a worksheet.protect "password" to the end of your code.

So you could either hide the worksheet (xlVeryHidden) or protect the cells and have the macro unprotect then reprotect them after the data is entered. If you use xlVeryHidden you may have to have the macro unhide the worksheet to enter data into it, depending on your macro.
Exactly what I wanted. Thanks!
__________________
Farewell, Necco Wafers. At least you died the way you lived: tossed away after someone realized they accidentally bought Necco Wafers. - Cedric Voets, Cracked.com
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


All times are GMT -4. The time now is 02:07 PM.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
*PLEASE NOTE: Posts are not checked for accuracy, and do not
represent the views of the Actuarial Outpost or its sponsors.
Page generated in 0.11642 seconds with 10 queries