Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Userform Macro
I have the following macro that I am trying to adapt to work with my user
form. The user form is to prompt for a password to run a macro that unhides a range of cells. I have not a clue what I am doing, but I am trying. Any help would be greatly appreciated. Sub Button1_Click() If TextBox1.Text < "1234" Then MsgBox "Invalid password - you cannot access this" UnHide.Hide Exit Sub Else Range("E17:E50").Select Selection.Font.ColorIndex = 0 Range("E17").Select ActiveSheet.Range("A1").Select End If End Sub Thanks Mike Rogers |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Editing a simple macro | Excel Worksheet Functions | |||
macro with F9 | Excel Discussion (Misc queries) | |||
Make Alignment options under format cells available as shortcut | Excel Discussion (Misc queries) | |||
how to run macro in userform button | Excel Discussion (Misc queries) | |||
Playing a macro from another workbook | Excel Discussion (Misc queries) |