Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Can anyone help please.
I have a workbook that records overtime and the code behind a button on the sheet is used to start a new 28 day period. It unprotects the sheet, stores the carried forward amount, clears all the entries, enters new dates and pastes in the stored carry forward amount and finally re-protects the sheet. It all works fine except that many of our users make a habit of unprotecting the sheet and entering values over the top of functions and then complain next month that the workbook is broken! I want to password protect the sheet but that breaks my code. Is there a way to include a password in the VB code? TIA - GA |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Very Novice Excel user with security question | Excel Discussion (Misc queries) | |||
Worksheet Protection | Excel Discussion (Misc queries) | |||
VLOOKUP for Zip Code Ranges | Excel Worksheet Functions | |||
Using other workbooks.. | Excel Worksheet Functions | |||
password protect vba code | Excel Discussion (Misc queries) |