#1   Report Post  
Posted to microsoft.public.excel.misc
Param
 
Posts: n/a
Default Password to open

Hi,

How to create macro :
1. prompt for password to open file.
2. prompt for password to go specific sheet.

TQ
  #2   Report Post  
Posted to microsoft.public.excel.misc
galimi
 
Posts: n/a
Default Password to open

You can have a dialog box pop up that contains a password protected text box
that will kick off on the Open event and Change_Sheet events.
--
http://HelpExcel.com
1-888-INGENIO
1-888-464-3646
x0197758


"Param" wrote:

Hi,

How to create macro :
1. prompt for password to open file.
2. prompt for password to go specific sheet.

TQ

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
If password is forgotten how to open a document Forgotton Password Protection Excel Discussion (Misc queries) 1 October 17th 05 01:22 PM
Import Data Keeps asking for Password Dominator Excel Discussion (Misc queries) 0 June 5th 05 11:25 PM
my "Password to Open" is grayed out TRexH52 Excel Discussion (Misc queries) 1 May 11th 05 09:15 PM
how do i give password to open for Excel File? SWATI GAMBHIR Excel Discussion (Misc queries) 1 February 24th 05 08:55 AM
Can no open workbook tandem Excel Worksheet Functions 4 December 1st 04 12:45 AM


All times are GMT +1. The time now is 04:53 PM.

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"