Using a Macro with the sheet protected.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I use a macro and have the sheet protceted at the same time.
 
Protect your worksheets with code with userfaceonly like this
Place this in the Thisworkbook module.

The macro's will be working now
It will only protect the userfaceonly

Right click on the Excel icon next to File in the menubar
And choose View code

You are now in the Thisworkbook module
Paste the Event in this place
Alt-Q to go back to Excel

Private Sub Workbook_Open()
Dim sh As Worksheet
Application.ScreenUpdating = False
For Each sh In ThisWorkbook.Worksheets
sh.Protect "ABCD", , , userinterfaceonly:=True
Next sh
Application.ScreenUpdating = True
End Sub
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ms word password recovery 1
Run Macro on All Sheets Q 8
Protecting sheet in a macro doesn't work 1
application.activesheet, should I use it? 3
Novice - using macro to protect with password 10
Macro to Combine Data from Multiple Sheets with Cell References 4
Copy data using macro (with worksheet protect) 5
Run macro from active workbook whose name keeps changing 20

Back
Top