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
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
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
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.