Search results for query: *

This seems to be one of these things that nobody has touched yet...

Hi, I would need some help/ideas how I can achieve the following - I would like to create a shared network printer on a domain print server that prints the job into a ps file in a specific folder on the server. How can this be achieved? Thanks, GP

Any suggestions? No?

Hi, I would need some help/ideas how I can achieve the following - I would like to create a shared network printer on a domain print server that prints the job into a ps file in a specific folder on the server. How can this be achieved? Thanks, GP

Heidi, Which value do you try to search for with vlookup - what should the particular cell in column P have as an example - a value like "$A$1" or the value of the cell A1? Gop

It appears that MS knows about this problem, but only for the versions Excel95/97: http://support.microsoft.com/default.aspx?scid=kb;en-us;140541

No problem - It is easy to unprotect and protect it again, but if the code (which is in the original file much bigger than in the example above) for whatever reason would raise an error the worksheet would be completely unprotected and I can't have that...

It's still a workaround but that would work. I'm still not sure if it's a bug or not. The MS docu says clearly: When you use the Protect method with UserInterfaceOnly argument set to True (UserInterfaceOnly=True), you protect the user interface but not macros. If this argument is omitted...

Skip, You are not as clever as you think. I would call your last message a workaround, but not the answer to the problem. Based on the docu VBA code should still be able to modify charts and cells when a sheet is protected with the option UserInterfaceOnly:=True. It works for Cells, but I...

If I would know that I would have solved the problem. I tried the following test: - The sheet is unprotected - I run the sub xy1- which worked fine: Sub xy1() With ActiveSheet.ChartObjects(1).Chart For Each x In .SeriesCollection x.Delete Next x End With End Sub - I re-added...

Skip, You just repeat yourself. It doesn't work your way.

hm, that would work, but I would rather like to use your idea but the other way round. Basically to have the selectable cells unlocked and to deny the user from selecting locked cells. if a user tries to change a cell to deny that by modifying the event methode in a similiar way to...

can you please specify what you mean with that question. I don't want to give a stupid answer like: to protect the sheet/to disable users to edit cells and charts.

Sorry, it was my fault. I left some quite important information out. the point is that the biggest part of the sheet should not be selectable - that part is locked. The part that is not locked should be selectable, but still not editable. To achieve the selection-bit I used the...

But than you can edit the cells - which I don't want to have.

Does anybody know how I can leave cells selectable but not editable when I protect a worksheet? cheers...

Skip, I created a complete new file with a chart just for testing purposes. I reduced the code as much as possible and could recreate the same behaviour. The code is as follows: Sub xy() ActiveSheet.EnableSelection = xlUnlockedCells ActiveSheet.Protect Password:="x"...

... the worksheet is unprotected before I run the code.

I can't remember anymore how you can hide the Row and Column headers - the row that shows the Column letter and the column that shows the row numbers. Any tips?

Skip, I'm not quite sure what information else I could give you besides the one that I have already posted: If I try to delete the series I get the error message: Run-time error 1004. The cell or chart you are trying to change is portected and therefore read-only. The debugger than jumps into...