Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello,
I have a question about a specific macro that I am trying to create. In this macro I want to have it so when a user enters in their first and last name in the two text boxes on my user form and click the command button titled login it will then take them to a specific range of cells which are named after the employee's name. Which will then be linked to a macro I wrote earlier where a specific cell is clicked within that range and the rest of the cells on the worksheet not in that range are locked and protected via password. Here is the code I have for the first macro. It's very simple but I was going for a basic code here since this is a mock. Sheets("Employee Tracker").Select Range("A25:M25").Locked = False Range("A25:M25").Select ActiveSheet.Protect Password:="testpass" ActiveWindow.ScrollColumn = 6 ActiveWindow.ScrollColumn = 5 ActiveWindow.ScrollColumn = 4 ActiveWindow.ScrollColumn = 3 ActiveWindow.ScrollColumn = 2 ActiveWindow.ScrollColumn = 1 Range("C3:C25").Select Range("C25").Select Thanks in advance for any help |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macro to copy a worksheet and rename based upon text entered in 1 | Excel Discussion (Misc queries) | |||
Creating a horizontal list of text values | Excel Discussion (Misc queries) | |||
HOW DO I PROTECT VALUES WHEN CREATING CLEAR CONTENTS MACRO? | Excel Discussion (Misc queries) | |||
Creating a macro to let a user use a keystroke for repeatative information | Excel Programming | |||
Add text in am macro bellow the already entered text | Excel Programming |