Macro - Playing Macro if cells are locked

  • Thread starter Thread starter sonar
  • Start date Start date
S

sonar

Hi

I want to create a macro to hide and unhide certain columns with "F
keys.

Will it work when most of my cells are locked and password protected?

Thanks
 
Sub MyMacro()
ActiveSheet.Unprotect Password:="ABCD"
' recorded code
Activesheet.Protect Password:="ABCD"
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

Run Macro If Cell have "x" value 0
Disable/enable or lock/unlock cells in VBA dependent on other cells values 2
Hide / Unhide each row from StartRow to LastRow for multiple conditions 6
Change macro button text when macro is invoked. 2
Format columns and cells in a protected sheet 2
Format columns & cells in a protected sheet - VBA code 2
VBA set thick borders around non empty cells in range 0
Macro protected work sheet 1

Back
Top