Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-25-2017, 07:30 PM
aussiemight aussiemight is offline Protect a workbook without using a password. Windows 10 Protect a workbook without using a password. Office 2016
Novice
Protect a workbook without using a password.
 
Join Date: Dec 2016
Posts: 3
aussiemight is on a distinguished road
Default Protect a workbook without using a password.

I've made an excel 2016 workbook for staff holiday planning. I want staff to be able to look at it so they can see at a glance when periods of leave are available, but I don't want them to be able to add anything to the workbook. They must supply me with leave forms & I'll be the only one able to enter into the workbook.

I've tried using password protection, but that means the staff need to know what the password is & it doesn't stop them from being able to make changes. I've also tried protecting the worksheet/s & workbook also using a password. This also doesn't stop them from making changes.



I want them to be able to open the workbook but not be able to make any changes. I also don't want to have to save the workbook with a different file name every time I make a change. Some of the options I've tried to-date have made me save the file with a different name each time I've entered anything into it.

If someone could steer me in the right direction it would be most appreciated.
Reply With Quote
  #2  
Old 04-26-2017, 06:29 AM
gebobs gebobs is offline Protect a workbook without using a password. Windows 7 64bit Protect a workbook without using a password. Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

Why do they need to know the password?
Reply With Quote
  #3  
Old 04-26-2017, 02:22 PM
aussiemight aussiemight is offline Protect a workbook without using a password. Windows 10 Protect a workbook without using a password. Office 2016
Novice
Protect a workbook without using a password.
 
Join Date: Dec 2016
Posts: 3
aussiemight is on a distinguished road
Default

That's the thing they don't need to know the password, however when I did password protect it they were unable to open it & look at it without the password. Hence my problem. I thought by password protecting it they would still be able to look at it (maybe read only) but it won't let them without the password. At present I'm stuck.
Reply With Quote
  #4  
Old 04-26-2017, 07:32 PM
Logit Logit is online now Protect a workbook without using a password. Windows 10 Protect a workbook without using a password. Office 2007
Expert
 
Join Date: Jan 2017
Posts: 456
Logit will become famous soon enoughLogit will become famous soon enough
Default

The simpliest method is to click on TAB (up top) REVIEW. Then PROTECT SHEET.

It will ask you for a password. Enter your password. Then it will request you confirm it, enter the password again.

That sheets is now protected.

You will need to do this for each sheet.

If you want an more automated process involving VBA macro code, let me know.
Reply With Quote
Reply

Tags
password protection, protecting a workbook, read-only.

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Protect a workbook without using a password. Password Protect a Macro Mark212 Word VBA 2 01-14-2015 02:30 PM
Password protect Docx documents timm@bicyclegermany.com Word 3 11-05-2011 03:46 PM
Protect a workbook without using a password. Here!! Help me to remove password protect from pdf priya Word 1 09-17-2011 10:35 AM
How can I protect all my MSW documents with a password ? Antonio Machado Word 0 07-05-2010 07:55 PM
Protect a workbook without using a password. password protect excel file? Dawg751 Excel 2 01-28-2010 06:23 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:55 AM.


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