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

Salary Surveys
Property & Casualty, Life, Health & Pension

Health Actuary Jobs
Insurance & Consulting jobs for Students, Associates & Fellows

Actuarial Recruitment
Visit DW Simpson's website for more info.

Casualty Jobs
Property & Casualty jobs for Students, Associates & Fellows

Thread Tools Search this Thread Display Modes
Old 06-07-2019, 10:47 AM
Bicycle Repair Man's Avatar
Bicycle Repair Man Bicycle Repair Man is offline
Join Date: Nov 2003
Posts: 14,341

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,
Reply With Quote

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 04:28 AM.

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.11340 seconds with 10 queries