Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-18-2016, 07:41 AM
ernief ernief is offline Unprotecting sheet in a macro Windows 10 Unprotecting sheet in a macro Office 2010 64bit
Novice
Unprotecting sheet in a macro
 
Join Date: Nov 2016
Posts: 5
ernief is on a distinguished road
Default Unprotecting sheet in a macro


Hi
I have successfully unprotected a sheet for sorting and then protected it again at the end of a macro button, but if there is a password on the protection it asks for that password before continuing. I do not want to give the password to other users. Can I program the password into the macro.
Thanks
Ernie
Reply With Quote
  #2  
Old 11-18-2016, 08:50 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is online now Unprotecting sheet in a macro Windows 7 64bit Unprotecting sheet in a macro Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,779
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Post moved to correct forum. Please save to the right forum in the future. Thanks
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Unprotecting sheet in a macro Unprotecting just one part of a protected form. snowboarder2 Word 1 08-24-2016 02:01 PM
Unprotecting specific fields on a Protected Document Slessor75 Word 3 03-12-2014 02:27 PM
Unprotecting sheet in a macro permanently unprotecting a sheet or workbook mrmagoo Excel 2 07-04-2012 08:12 PM
copy cell from sheet 2 to sheet 3 macro slipperyjim Excel Programming 1 02-18-2010 01:31 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:01 AM.


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