LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Password Setting


hi hi, it is so nice to have this forum...

I have a query on VBA programming regarding password setting. How to
set up a password when opening a file. good to have expiry date!! I
tried once before to write a macro to lock the file. However, if the
user choose "disable macros", then it does not work! Is there any way
out?? I know there is a built-in funtion in Excel to protect a file
from reading or writing upon opening. But there is no expiry date
attached!! thank you for yr help!!! :)


--
VBALearner
------------------------------------------------------------------------
VBALearner's Profile: http://www.excelforum.com/member.php...o&userid=26019
View this thread: http://www.excelforum.com/showthread...hreadid=393734

 
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
Setting password on worksheet in Excel 2000 Bill[_2_] Excel Worksheet Functions 1 February 14th 07 07:05 PM
Setting VBA Project Password Howard Kaikow Excel Programming 4 May 18th 05 03:28 PM
Setting an Open-file password Terry Excel Programming 3 April 6th 05 01:24 AM
Setting Password & WriteResPassword Kevin H. Stecyk[_2_] Excel Programming 0 January 27th 05 02:16 AM
Setting worksheet protection password in VBA Mark Bochner Excel Programming 0 October 6th 03 10:59 PM


All times are GMT +1. The time now is 08:51 AM.

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

About Us

"It's about Microsoft Excel"