How to hide and lock all cells but A1?

  • Thread starter Thread starter Pat
  • Start date Start date
P

Pat

I can write a macro that gets the last cell and figures out the ranges of
rows and columns that do not play but is there an easier way to do this?
Pat
 
Are you looking for

Cells(1, 1).Locked = False
Rows("2:" & Rows.Count).Hidden = True
Range(Columns(2), Columns(Columns.Count)).EntireColumn.Hidden = True
ActiveSheet.Protect

If this post helps click Yes
 
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

VBA set thick borders around non empty cells in range 0
Disable/enable or lock/unlock cells in VBA dependent on other cells values 2
Hiding Columns based on cell value 3
VB Code to hide rows 3
hiding blank rows 3
Locking specific cells 1
hide colum based on cell value on each worksheets 2
conditional format based on column statistics and loop over columns 1

Back
Top