Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 105
Default Protecting Sheets with VBA

I have a user who feels they need to password protect some of the cells on a
sheet befor they distribute their sheet. The problem is they are a little
absent minded and forget to go to the Tools=Protection=Protect Sheet menu
item and lock the sheet before they save it.

Is it possible upon closing to lock the sheet with the password they used to
unlock it with?
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default Protecting Sheets with VBA

Not unless they record that password somewhere.

--
Regards,
Tom Ogilvy

"Helen" wrote in message
...
I have a user who feels they need to password protect some of the cells on

a
sheet befor they distribute their sheet. The problem is they are a little
absent minded and forget to go to the Tools=Protection=Protect Sheet

menu
item and lock the sheet before they save it.

Is it possible upon closing to lock the sheet with the password they used

to
unlock it with?



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
Protecting Sheets Joyce Excel Worksheet Functions 3 March 20th 06 09:18 PM
Protecting Sheets albertmb Excel Discussion (Misc queries) 7 March 13th 06 10:13 PM
Protecting buttons with VB code rather than protecting sheets/books? StargateFanFromWork Excel Programming 2 July 16th 04 04:03 PM
Protecting sheets LC[_5_] Excel Programming 1 February 19th 04 06:14 AM
Protecting Sheets PeteD Excel Programming 4 October 4th 03 08:13 PM


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

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"