saving

[cocacola]

if i do a save on one worksheet, does that save all info in my entire workbook?

 

[Von Pookie]

Yes.

 

[Chris Davison]

Yes.

unless..... some unscrupulous character has inserted a "before save" macro into your worksheet which you are unaware of ...

ie

<PRE>

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)

Range("A1").Value = 999999

End Sub

</PRE>

which, although having no value whatsoever other than to screw you up, would make the cell A1 equal to 999,999 before you saved your worksheet

I'd go with Von Pookie's answer though, unless you have some psychopath in your office......

Hope this helps,
Chris

 

[Von Pookie]

Since Chris' usage of the PRE tag made his post go wonky, this is the explanation of the macro:

which, although having no value whatsoever other than to screw you up, would make the cell A1 equal to 999,999 before you saved your worksheet

Gotta proof those messages after you post 'em, Chris! :wink:

_________________<font color="#3399FF" size="3">Kristy</font>

This message was edited by Von Pookie on 2002-10-21 16:18

 

[Mark O'Brien]

To answer the question, yes.

Actually this is the reason I'm posting to this thread:

Christoff, whence using the <pre> tags, I've found that the remaining text in your message can get screwed up unless you place the </pre> tag right after your last line of code e.g.:

<pre>
Dim i As Integer


For i = 1 to 100
Msgbox "God this is an annoying piece of code." & vbNewline & "Pressing CTRL+BREAK will corrupt your system." & vbNewline & "You only have to hit the OK button " & i " more times".
Next</pre>

HTH