View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Gavin[_5_] Gavin[_5_] is offline
external usenet poster
 
Posts: 1
Default Request password during Protect macro


Hi.
I have a macro that unprotects and protects a Sheet & Workbook, but I
want excel to prompt the user to provide the password as if they had
selected protect/unprotect from the menu. How do I do this?
Thanks for any help.
Regards
Gavin


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/