| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
help with protection of sheets
please help
i have a petty cash workbook file where there is a new sheet generated via a macro for each day. the new sheet is generated by copying today's sheet and clearing the contents for the new day. the date is entered into this new sheet in cell E1, which then automatically becomes the sheet name of the new one. is it possible to create vb code to automatically lock yesterday's sheet for editing and hide it, so that at any point the financial person sees only today's sheet - if so, could someone help with the code |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Protection of many sheets | Excel Worksheet Functions | |||
| Applying Protection To Multiple Sheets | New Users to Excel | |||
| Password protection for Excel sheets | Excel Discussion (Misc queries) | |||
| Protection and Hiding Sheets | Excel Discussion (Misc queries) | |||
| Changing password protection on sheets | Excel Discussion (Misc queries) | |||
![des-sa[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
