Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. niknik24

    Allow users to edit ranges

    i think i'm with you now - right click cell format - cell locked or not thanks v much Nik
  2. niknik24

    Allow users to edit ranges

    i think i have done that- what would i need to do. what does the actual code for allowing editing ranges in protection look like? thanks Nik
  3. niknik24

    Allow users to edit ranges

    Hello I am trying to cretae a code that protects my worksheets but allows users to edit ranges. I want the editable ranges to be 'Named Ranges' from the active sheet. I have tried simply recording myslef doing this but cannot seem to make it work. Any help would be appreciated. Thanks Nik
  4. niknik24

    Naming a Sheet with cell values VBA Excel

    Hello I am trying to create a macro that allows me to copy paste the following range ("a3:b3") and then rename the active sheet name with the copied range Is this possible Thanks Nik
  5. niknik24

    Adding a Popup Calendar to a Userform

    Thanks Taupirho - very useful - i've managed it now - always seems to take a while to sink in
  6. niknik24

    Adding a Popup Calendar to a Userform

    PLEASE IGNORE THAT I FIGURED IT OUT - THANKS
  7. niknik24

    Adding a Popup Calendar to a Userform

    Sorry Andy What is Month view 1
  8. niknik24

    Adding a Popup Calendar to a Userform

    Hi Andy - Thanks I have the control but i can't seem to make it all work. Basically i want my user to be filling information in on my userform, then they clcik a comman button and a calender pops up which will populate a field on my userform1 does that make sense Thanks
  9. niknik24

    Adding a Popup Calendar to a Userform

    Hello I am trying to create a userform that will allow people to input data into an excel spreadsheet in a controlled way. I would like to include a date field and would like to have a popup calendar on my userform. is this possible? Thanks Nik
  10. niknik24

    Tie Breaking Rank problem excel 97

    Thanks very much, no worries about the wait. I don't have internet away from work so but am back monday if needs be. Appreciate the help a lot thanks Nik
  11. niknik24

    Tie Breaking Rank problem excel 97

    yeah that right, after the games in question results it goes to goal difference. thanks
  12. niknik24

    Tie Breaking Rank problem excel 97

    Hello Yes thats correct, they play twice Thanks
  13. niknik24

    Tie Breaking Rank problem excel 97

    Hi Yeah i have a results section in my spreadsheet, 1 result per row. England 1 0 Estonia Each team plays 12 times and there are 7 teams in the league. from there i have a few specific stages i go through to begin calcualting my league. The problem arises obviously when the teams...
  14. niknik24

    how to show column titles when scolling down

    Hello I think from your probelm, unless i have misread, that you need to use the freeze panes function. Click in the cell leftmost and 1 below where your titles are (so if your column titles is a1 you would click in b1) and then Go to Window, then freeze pains. This will lock your titles in place.
  15. niknik24

    Tie Breaking Rank Problem Excel 97

    Hello I am trying to create a excel planner for the football euro2008 qualifying tournemant. I have a problem, i am familair with creating league tables using the rank function but this is of no use here. the rules for euro 2008 are that if 2 teams finish with the same points then the results...
  16. niknik24

    Tie Breaking Rank problem excel 97

    Hello I am trying to create a excel planner for the football euro2008 qualifying tournemant. I have a problem, i am familair with creating league tables using the rank function but this is of no use here. the rules for euro 2008 are that if 2 teams finish with the same points then the results...

Part and Inventory Search

Back
Top