Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Expiry Date for further updates into Sheet
There is a way to force user to enable macros.
Sub auto_close() Sheets("Sheet1").Visible=xlVeryHidden End Sub Sub auto_open() Sheets("Sheet1").Visible=True End Sub -- Marcin GG13349 przy kontakcie GG proszę napisać, że jeste¶ z grupy niusowej nie odpowiadam różnym dowcipasom, zaczynaj±cym od "cze, ile masz lat?" ----------------------------------------------- wywal ".wywalto." z mojego adresu e-mail, ----------------------------------------------- Serwis Usenet w portalu Gazeta.pl - http://www.gazeta.pl/usenet/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Expiry Date for further updates into Sheet
Unfortunately, all the user has to do to defeat this method is to
save the workbook once it's open, and decline to save it when it's closed. The worksheet will be unhidden the next time the file is opened, even if macros are disabled. The routine could be more sophisticated by using a Before_Save event macro to hide the sheet(s) again, save, then unhide them, but that's not too hard to bypass either. Note that xlVeryHidden doesn't really hide the worksheet very well - xlVeryHidden worksheets are still listed in the Contents pane of the Properties dialog. And it doesn't really address the issue of the OP - simply setting the system clock back will allow entries after the expiration date. Any sufficiently motivated person of average intelligence, especially if they have access to these groups, can bypass any protection scheme that XL has - it's just not a secure platform. In article , (mk) wrote: There is a way to force user to enable macros. Sub auto_close() Sheets("Sheet1").Visible=xlVeryHidden End Sub Sub auto_open() Sheets("Sheet1").Visible=True End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to calculate expiry date | New Users to Excel | |||
Expiry of Excel Sheet or WorkBook | Excel Worksheet Functions | |||
VBA For Expiry date | Excel Discussion (Misc queries) | |||
Expiry date | Excel Worksheet Functions | |||
Expiry Date for further updates into Sheet | Excel Programming |