EXCEL – Reminder

02/10/2015 § Leave a comment

Application.ScreenUpdating = False
Application.ScreenUpdating = True

..::..

Worksheets(“Menu”).Select
Sheets(“Menu”).Activate
Range(“A1”).Select

..::..

Hide Rows
Rows(“15:20”).Select
Selection.EntireRow.Hidden = True

..::..

Protect / Unprotect Sheet

Sheets(“Menu”).Protect Password: = “22”
Sheets(“Menu”).Unprotect Password: = “22”

..::..

Deselect Range After Macro

Application.CutCopyMode = False

..::..

Formula =SHEETNAME()

Function SheetName()
SheetName = ActiveSheet.Name
End Function

..::..

 

Advertisements

Tagged: ,

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

What’s this?

You are currently reading EXCEL – Reminder at RheXenoR.

meta

%d bloggers like this: