Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
mk mk is offline
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 493
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to calculate expiry date Justina New Users to Excel 6 August 19th 11 07:20 PM
Expiry of Excel Sheet or WorkBook Hardeep kanwar Excel Worksheet Functions 1 March 30th 09 07:26 AM
VBA For Expiry date Alam Excel Discussion (Misc queries) 1 November 18th 07 12:36 PM
Expiry date Martina Excel Worksheet Functions 6 February 11th 07 10:57 PM
Expiry Date for further updates into Sheet J.E. McGimpsey Excel Programming 0 July 11th 03 04:43 AM


All times are GMT +1. The time now is 02:45 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"