Skip to main content

Posts

Showing posts with the label Protect Sheet using VBA

Unprotect and Protect Sheet using VBA code

How to write to protected Excel file using VBA Here is a sample to unprotect a sheet and write some values and then protect the sheet again Sub Unprotect_And_ThenProtect() ActiveSheet.Unprotect Range("A2").Value = Now() ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True End Sub

Facebook

Facebook Recommendations

Followers


Web Designing In Karachi



Haroof.com


Politics blogs

My Zimbio

Email Subscribe

Enter your email address:

Watch online Live TV

Labels

Show more