Solved

#Excel work sheet macros issues

Posted on 2007-03-26
9
279 Views
Last Modified: 2010-04-16
Hi,
I'm new to VB and thwe macros that run behind worksheets, we have a new employee who needs to be added to a drop down list in an excel worksheet. Can some one point me in the right direction - idiots guide ?
Thanks,
Ger
0
Comment
Question by:ger2222
  • 5
  • 4
9 Comments
 
LVL 85

Expert Comment

by:Rory Archibald
ID: 18792459
Hi,
It depends what kind of dropdown list it is. Does the dropdown only appear when you select a cell, or is it always visible? If the latter, do you know whether it came from the Control Toolbox or the Forms toolbar?
Regards,
Rory
0
 

Author Comment

by:ger2222
ID: 18792481
The dropdown only appears when i select the cell.
Hope this helps
0
 
LVL 85

Expert Comment

by:Rory Archibald
ID: 18792520
In that case, there is probably no code involved. If you select the cell, choose Data-Validation from the menu, you will probably see that the Allow box is set to List and the Source box is set to a typed in list (unlikely), a range reference or a named range. For the first one, you could just type the new name in; for the range reference, you can just extend this by one row, then type the new name into that row on the worksheet; for a defined name, you will need to locate the data that the name refers to (you can do this via Insert-Name-Define form the menu, select the name in the list and then check the 'refers to' range. Again, add the new data in the next row, then update the name as necessary.
Regards,
Rory
PS If the name has been defined dynamically (using an OFFSET construction) you may just be able to add the new name in the next row and it will be picked up automatically.
0
Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

 

Author Comment

by:ger2222
ID: 18792546
Hi,
The validation option is greyed out, i dont have the password to unprotect the sheet, how can i get around this? I'm new to thje job so dont have the password.
0
 
LVL 85

Expert Comment

by:Rory Archibald
ID: 18792583
You can't change the validation if the sheet is protected so you have two options:
1. Find someone who does have the password! :)
2. Break the password. The code to do so is fairly basic or you can use a commercial tool. (I'm never entirely happy publishing code to do this but you can google it easily enough if necessary)
Regards,
Rory
0
 

Author Comment

by:ger2222
ID: 18792633
ok, i got the worksheet unprotected and can see the formula but colum U is hidden , how do I unhide just column U
0
 
LVL 85

Accepted Solution

by:
Rory Archibald earned 250 total points
ID: 18792662
Select columns T and V and choose Format-Column-Unhide from the menu.
0
 

Author Comment

by:ger2222
ID: 18792675
got it, thanks for your help and patience, thats my something new for today!!!  :)))
0
 
LVL 85

Expert Comment

by:Rory Archibald
ID: 18792719
Glad to help! Thanks for the grade.
Rory
0

Featured Post

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Although it can be difficult to imagine, someday your child will have a career of his or her own. He or she will likely start a family, buy a home and start having their own children. So, while being a kid is still extremely important, it’s also …
When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
In this fifth video of the Xpdf series, we discuss and demonstrate the PDFdetach utility, which is able to list and, more importantly, extract attachments that are embedded in PDF files. It does this via a command line interface, making it suitable …

813 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now