Search results for query: *

I believe that it's possible to see who has been accessing my lotus notes calendar. Any ideas?

why not try a simple macro one entry is complete which autofits the data in column B of sheet 3; Columns("B:B").EntireColumn.AutoFit AshB

quickest way I know without using VBA would be to do the following with a set of figures in column A: 1. sort them (so the duplicates are next to each other) 2. use some formula in a spare column such as =if(a2=a1,"*",0)in row 2 =if(a3=a2,"*",0)in row 3 and copy down to...

thinking about a simple solution, you could open the spreadsheet in the VB macro and then close it once you have picked the information you are refering to. Eg. Workbooks.Open Filename:="C:\Johny\test.xls Sheets("Sheet1").Select Range("D1").Select and then do what...

Perhaps I am misinterpreting your query to be too simplistic? ='C:\Johny\[test.xls]Sheet1'!$D$1 AshB

Hi there, I have a set of 100 unique items, which I need to allocate randomly between 10 'names'. Each of the 10 names should be allocated an even number ie. 10. Is there a fairly simple bit of code that can do this? Any help would be appreciated. Thanks in advance AshB

Thanks geoff I found an alternative - using the format - cell protection - hidden. that way i don't have to hide the formula bar for all cells. Ashb

I have protected a number of cells within an excel worksheet, so that other users cannot alter the formula. I think there is a way to restrict them actually seeing the formula in these protected cells, but I can't work out how. Any help would be appreciated. Ashb