Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-07-2020, 12:52 AM
allex011 allex011 is offline Help pop up message with password Windows 7 32bit Help pop up message with password Office 2007
Advanced Beginner
Help pop up message with password
 
Join Date: Dec 2017
Posts: 39
allex011 is on a distinguished road
Default Help pop up message with password


Is it possible to make excel workbook with several sheets who are password protect (you can not see sheet content until password is insert).Password would be different for every sheet?
Thanks in andvanced
Reply With Quote
  #2  
Old 03-07-2020, 10:13 PM
PrincessApril PrincessApril is offline Help pop up message with password Windows 10 Help pop up message with password Office 2019
Competent Performer
 
Join Date: Nov 2019
Posts: 102
PrincessApril is on a distinguished road
Default

At least in newer versions of Excel, you can right click the Sheet tab and choose "Protect Sheet," then follow the instructions. To view the worksheet, you have to right click the tab again and choose "Unprotect Sheet" (which will prompt the pop-up message to enter the password). Looks like lost passwords cannot be retrieved though, so something to keep in mind.

For 2007, it looks like the option might be under the Review tab, at least according to this help file: Protect Files, Sheets and Cells in Excel 2007 - Knowledgebase / Software / Microsoft Office - Brown IT Service Center
Reply With Quote
  #3  
Old 03-08-2020, 03:47 PM
NoSparks NoSparks is offline Help pop up message with password Windows 10 Help pop up message with password Office 2010
Excel Hobbyist
 
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 831
NoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really nice
Default

This of any use?
Attached Files
File Type: xlsm Password_to_see_sheets.xlsm (23.8 KB, 12 views)
Reply With Quote
  #4  
Old 03-08-2020, 04:39 PM
PrincessApril PrincessApril is offline Help pop up message with password Windows 10 Help pop up message with password Office 2019
Competent Performer
 
Join Date: Nov 2019
Posts: 102
PrincessApril is on a distinguished road
Default

That is pretty cool.
Reply With Quote
  #5  
Old 03-08-2020, 05:52 PM
NoSparks NoSparks is offline Help pop up message with password Windows 10 Help pop up message with password Office 2010
Excel Hobbyist
 
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 831
NoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really nice
Default

Thanks.
Hope the OP takes a look.
Reply With Quote
  #6  
Old 03-13-2020, 10:58 PM
allex011 allex011 is offline Help pop up message with password Windows 7 32bit Help pop up message with password Office 2007
Advanced Beginner
Help pop up message with password
 
Join Date: Dec 2017
Posts: 39
allex011 is on a distinguished road
Default

Thank you, this is great
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Create Custom Form in Outlook 2016, for the Message setting 'Do not include original message' jsvictor1989@gmail.com Outlook 0 01-30-2019 10:54 PM
Help pop up message with password keeps asking for password roberto Outlook 1 04-14-2017 07:43 AM
Password protected file no longer offers password dialog on Open htaylor Word 0 10-15-2013 12:35 PM
Help pop up message with password Message replys are shown at the bottom of the message, how can I get them to the top Gardy Outlook 3 05-23-2012 01:20 AM
Help pop up message with password Outlook requests password afeter changing windows password pask Outlook 5 03-16-2012 08:43 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:23 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft