The machine was overdue for a reinstall so I bit the bullet and did it yesterday. When I set it up I followed smah's suggestion and it is working as it should not. I will let you know if it changes.
Thanks gents for the assist.
I enabled Remote Desktop on my desktop machine and established a password for my user account. I was then able to log on from my notebook from a remote location.
When I would return to my desktop the logon window was waiting for me where upon I would enter the password and go.
I now have to log...
Unfortunately I don't have much leeway with this computer. It is controlled by the IT guys and they won't let me lower security settings.
I shall experiment on my home unit
Actually, you are correct. The unlocked columns in the contiguous range of columns do sort correctly and the two locked columns only appear to sort.
The reason is (in my mind) quite simple. The contents of the two protected columns are formulas. Once I placed the two locked columns to the...
Thanks Skip:
In inspecting the columns that are protected there is no header. When I try Data | Sort - there is no header however, I might not be looking at the right thing though as per your post.
I have found a work around which is satisfactory but I would like to sort this out somehow...
I am revisiting this post.
The "Allow users to use AutoFilter" works fine however when I try to Sort all columns (i.e. ascending or descending) I get the error "the cell you are trying to change is protected and therefore read-only".
When protecting the worksheet I did check the Sort option...
From time to time some of my recipients (and only some) notify me that they get everything I am sending twice. Other recipients only get a single copy. The emails always arrive within a minute of each other and they are always exact copies.
I am using Outlook 2003 and have server timeout set...
I find that I cannot auto filter a column in Excel if any of the cells in adjacent columns are locked and the worksheet protected.
Does anyone know a work around for this?
Thanks
I have a situation that is driving my wife nuts. When she is playing a game on Yahoo Games from time to time (No pattern) IE7 will close without notice. It just seems to be on Yahoo Games. She has not noticed it when anywhere else (mind you she is rarely anywhere else).
The machine is running...
I am in Canada. I was aware that you could change the region on the DVD drive but I thought it was only once.
Thanks, I shall find out more info from her and possibly get back to Tek-Tips
It's video.
If she uses a program such as Nero will I be able to play the DVD on my PC or what settings might she have to make at her end for me to view it?
Thanks
A friend from Germany would like to send me DVD. Can my PC's DVD reader/burner play it without changing any settings? Does she have to do anything special in burning it?
She also asked in which format it is the best to burn them.
Any help appreciated
TIA
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.