saving

cocacola

New Member
Joined
Oct 16, 2002
Messages
26
if i do a save on one worksheet, does that save all info in my entire workbook?
 

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.

Chris Davison

MrExcel MVP
Joined
Feb 15, 2002
Messages
1,790
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

MrExcel MVP
Joined
Feb 17, 2002
Messages
13,686
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>
kitten_smush2.jpg

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

Mark O'Brien

MrExcel MVP
Joined
Feb 15, 2002
Messages
3,530
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
 

Forum statistics

Threads
1,144,354
Messages
5,723,884
Members
422,524
Latest member
wirkkarn

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top