Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Require a password to execute a macro


After some searching Have found code examples to accomplish this with a
inopuit box. But the password is not hidden when entered. I believe
user form would accomplish this, buty i am clueless as to how to writ
the code for a password required which is hidden by characters such a
asteriks. Any help would be appreciated.


ti

--
Rjeffa
Posted from - http://www.officehelp.i

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,452
Default Require a password to execute a macro

Look at the property: PasswordChar of the textbox control.
Make it something like * and it will do exactly what you want.

RBS

"Rjeffay" wrote in message
...

After some searching Have found code examples to accomplish this with an
inopuit box. But the password is not hidden when entered. I believe a
user form would accomplish this, buty i am clueless as to how to write
the code for a password required which is hidden by characters such as
asteriks. Any help would be appreciated.


tia


--
Rjeffay
Posted from - http://www.officehelp.in


  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Require a password to execute a macro


the "code" is the macro. ineed a setup which will not allow a macro t
run unless a password is entered. But I need the password to onl
display astericks when entered. I am not knowlegable to create this.
am looking for some help which I could just put into excel

--
Rjeffa
Posted from - http://www.officehelp.i

  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,452
Default Require a password to execute a macro

I still don't understand what the precise problem is.
I am sure it is something simple to solve, but you will have to explain
better what exactly you are trying to do.

RBS

"Rjeffay" wrote in message
...

the "code" is the macro. ineed a setup which will not allow a macro to
run unless a password is entered. But I need the password to only
display astericks when entered. I am not knowlegable to create this. I
am looking for some help which I could just put into excel.


--
Rjeffay
Posted from - http://www.officehelp.in


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
Require a macro for Excel 2007 pcor New Users to Excel 4 May 14th 08 01:34 AM
I require code to run a macro dependant on the date Marie Bayes Excel Discussion (Misc queries) 7 January 15th 07 03:48 PM
Require certain password for sheet1 to save mikeburg[_61_] Excel Programming 0 January 14th 06 04:06 AM
Require password to execute macro richinlaf31[_4_] Excel Programming 0 August 3rd 05 07:13 PM
require password each time a macro is executed Marty Excel Programming 6 October 10th 04 08:13 PM


All times are GMT +1. The time now is 01:16 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"