Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Print hidden sheets
Register FAQ

Reply
 
Thread Tools Display Modes
  #1  
Old 11-24-2019, 10:09 AM
Logit Logit is offline Print hidden sheets Windows 10 Print hidden sheets Office 2007
Expert
  
Join Date: Jan 2017
Posts: 591
Logit is a jewel in the roughLogit is a jewel in the roughLogit is a jewel in the roughLogit is a jewel in the rough
Default
.


ActiveSheet.Unprotect "pwd" '<--=- replace pwd with your actual password in quotes.

ActiveSheet.Protect "pwd"
Reply With Quote
  #2  
Old 11-24-2019, 01:04 PM
GregT GregT is offline Print hidden sheets Windows 10 Print hidden sheets Office 2016
Novice
Print hidden sheets 		 
Join Date: Nov 2019
Posts: 3
GregT is on a distinguished road
Default
Quote:
Originally Posted by Logit View Post
.
ActiveSheet.Unprotect "pwd" '<--=- replace pwd with your actual password in quotes.

ActiveSheet.Protect "pwd"
Thanks!! will give this a try.
Reply With Quote
Reply

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
One veryhidden sheet, one hidden sheet and two visible sheets - how to saveas into .xlsm workbook kiwimtnbkr Excel Programming 4 06-26-2019 11:30 AM
Print hidden sheets How can set a command to print only specific sheets? terrymac Excel Programming 2 12-01-2015 05:29 PM
Print hidden sheets Print Area - setting Print Area on large sheets nfotx Excel 2 12-27-2014 10:21 PM
Print Multiple Sheets Double-Sided flambe99 Excel 1 03-12-2010 01:15 PM
Print with hidden cols? markg2 Excel 2 01-06-2010 06:04 PM

Other Forums: Access Forums

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

Contact Us - Privacy Statement - Top

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