[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

#Excel work sheet macros issues

Posted on 2007-03-26
9
Medium Priority
?
315 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
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 

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 1000 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

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Question has a verified solution.

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

This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
Simple Linear Regression
How can you see what you are working on when you want to see it while you to save a copy? Add a "Save As" icon to the Quick Access Toolbar, or QAT. That way, when you save a copy of a query, form, report, or other object you are modifying, you…

612 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