Replies

Hello

If the problem is with the “Documents and Settings” folder can you move your PST file to a different location that both users could see? Then she could see your PST because it is not off limits, and because you are an administrator you can still see hers in the “Documents and Settings” folder. Just a suggestion. I always move my stuff out of “Documents and Settings” folders to a second drive so that if I have to rebuild the computer I don’t loose my data and I also just backup the whole second drive.

Hello

For you keyboard commandos.
Move the cursor to the first file/message to be selected and press and hold the key down.
Use the mouse to move the cursor to the next file/message you wish to select.
Pressing the bar and it will be selected as well.
Press the bar on a highlighted file/message will deselect the file/message.

You can also hold the key and select a large section and then use the above to deselect a couple of files/messages.

Hope this helps.

In my programs I also shut off calculation to speedup the application.
I use

Application.Calculation = xlManual
Application.ScreenUpdating = False

at the start and use

Application.Calculation = xlAutomatic
Application.ScreenUpdating = True

at the end.

Hope this helps.

You paid for Office 2000 full version.
You paid for Office XP Upgrade.
You paid for Office 2003 full version.
You can do anything you want with office 2000 but if you donate/sale Office XP you must also include Office 2000.
I have donated old versions away and did not keep copies, which is what is required to keep Microsoft off your back.
If they change the rules with new versions that does not change the rules for older versions.
If your genurose gift will help someone else then give away.

Good Day,

The original problem is that Excel asks to save changes when you have not made any?
Excel always asks to save changes if you have any formulas that recalculate.
If you open a new worksheet and close without making any changes Excel should close quietly.

Good Morning

What if you change the order of the rule so that you check for “TPW” first then folow with the other rules?

Hello Don,

It looks like you are trying to remove the vertical page break after you have hid the columns.
What happens when you put the .VPageBreaks.Delete .Range(“M1”) before the .Columns(“M:V”).Hidden = True

You state that you are able to save settings in an >Options Form<, is this a form saved on a server? If so could you show me an example so that I could finish a project that I have worked on for quite a while.
Thank You

Here is a quick fix that I created.
The problem is that your symbols are not numeric and can not be shown in a graph.
I changed the date to have 4 columns(Date, Data, Split, Buy)
Then had the Split and buy dates = the Data column at the point of transaction.
I then formated the points to be unique and used the default colors in the symbols.

I have posted the modified chart for you to see what I have done.

Here is a quick fix that I created.
The problem is that your symbols are not numeric and can not be shown in a graph.
I changed the date to have 4 columns(Date, Data, Split, Buy)
Then had the Split and buy dates = the Data column at the point of transaction.
I then formated the points to be unique and used the default colors in the symbols.

I have posted the modified chart for you to see what I have done.

(Edited by paulbonney on 28-Oct-04 07:26. Just a quick update to use code standard naming practice and also to use the free file option)

Mark

Here is a modified version of what I did for a old project

Sub Key()
Dim dDate As Date
Dim sIndex As String
Dim iFileNO As Integer
iFileNO = FreeFile

On Error GoTo NoIni
‘ Read Data from ini file
Open “C:TempKey.ini” For Input As #iFileNO
On Error GoTo BadIni
‘ Read data into all variables
Input #1, dDate, sIndex
‘ Close before reopening in another mode.
Close #1
GoTo Ini

‘ Initialize a new INI file
NoIni:
dDate = Date
sIndex = 0
Close #1
GoTo Ini

‘ Found but had errors
BadIni:
dDate = Date
sIndex = 1
Close #1
GoTo Ini

Ini:
On Error Resume Next
‘ Check to see if new Date
If dDate Date Then
dDate = Date
sIndex = 0
End If

‘Increments counter
sIndex = sIndex + 1
‘ formats counter to 5 digits
sIndex = Right(“00000” + sIndex, 5)
dDate = Date
‘ Save Data to ini file
Open “C:TempKey.ini” For Output As #iFileNO
Write #1, dDate, sIndex
Close #1 ‘ Close file.
End Sub

Good luck and I hope

The one thing to add to this sub is the center function and then you would have all that you asked for.

~~~
With Range(“D” & ocell.Row)
.Value = (Range(“C” & ocell.Row).Value – Range(“B” & ocell.Row).Value) / Range(“B” & ocell.Row).Value
.NumberFormat = “0.00%_ ;[red ]-0.00%;0%”
.HorizontalAlignment = xlCenter
End With
~~~

Hope this helps

The one thing to add to this sub is the center function and then you would have all that you asked for.

~~~
With Range(“D” & ocell.Row)
.Value = (Range(“C” & ocell.Row).Value – Range(“B” & ocell.Row).Value) / Range(“B” & ocell.Row).Value
.NumberFormat = “0.00%_ ;[red ]-0.00%;0%”
.HorizontalAlignment = xlCenter
End With
~~~

Hope this helps