Search results for query: *

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

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

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

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

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

PLEASE IGNORE THAT I FIGURED IT OUT - THANKS

Sorry Andy What is Month view 1

thanks a lot

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

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

cheers

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

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

Hello Yes thats correct, they play twice Thanks

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

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.

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

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