Sheets-Worksheets

Here, you can,

Perform various actions on your Worksheet. To make it easier, the Worksheet that contains most of your data will now be called the ‘Database’,

Hide a Form and activate a Worksheet. (Watch the Video)

Add and Name a new Worksheet from a TextBox. (Watch the Video)

Protect a Worksheet with a Password. (Watch the Video)

Unprotect a Worksheet. (Watch the Video)

Hide a Worksheet. (Watch the Video)

Make a Worksheet disappear. (Watch the Video)

Display a Worksheet. (Watch the Video)

Protect and Hide a Worksheet. (Watch the Video)

Duplicate and Rename a Calculation Sheet Based on Values of 2 Cells (Watch the Video)

Change the Tab Color of a Worksheet. (Calculate your color) (Watch the Video)

Insert a Title in the Headers of the Worksheet. (Watch the Video)

Insert a Title in the Footers of the Worksheet. (Watch the Video)

Get the Number of the last row with text. (Watch the Video)

Get the Name of the last column with text. (Watch the Video)

Export a Worksheet to PDF format (on Desktop). (Watch the Video)

Simply, insert the requested value in the box, click on the “Get the Code” button and Hop, the code appears in the square at the very bottom of the page… copy and paste it into your UserForm…That’s it 🙂

Hide a Form and activate a Worksheet:




Add and Name a new Worksheet from a TextBox:




Protect a Worksheet with a Password:




Unprotect a Worksheet:




Hide a Worksheet:




Make a Worksheet disappear:




Display a Worksheet:




Protect and Hide a Worksheet:




Duplicating and renaming a calculation sheet based on two cells:






Change the Tab Color of a Worksheet:




Insert a Title in the Headers of the Worksheet:


Insert a Title in the Footers of the Worksheet:


Get the Number of the last Row with text:




Get the Name of the last Column with text:




Export a Worksheet to PDF format (on Desktop):