top of page
  • Writer's pictureKalpesh Agrawal

VBA Activate and Protect the worksheet

Activate the worksheet

In excel you can activate the sheet by clicking on the sheet tab, in VBA there is an easy code to activate the sheet, Let’s see the code.

Protect the Sheet

It is crucial to protect the sheet when you are working on some confidential data, and you don’t want to allow anyone to open that worksheet without permission.

Let’s see the code to protect the sheet.

Related: VBA Add sheet, rename the sheet, and add a sheet with the name
Related: VBA Sheet Referencing & Getting Sheet Name
Related: VBA Hide and Unhide the Columns and Rows

Written by: Kalpesh Agrawal (Actuarial Intern - IIB)


Related Posts

See All
bottom of page