About Us

aceuk

Quote:

Originally Posted by JW[_2_]

Do you mean when you close a particular workbook? If so, open the
VBE, select the ThisWorkbook module and place this:
Private Sub Workbook_BeforeClose(Cancel As Boolean)
If MsgBox("Did you remember to update total " & _
"of customers?", vbYesNo) = vbNo Then Cancel = True
End Sub

riley2007 wrote:
i want to create a pop up window so when i x excel, it pops up like an error
message. so it says 'did you remember to update total of customers' with a
yes and return button. Please help me :D

Hi
I am a real novice at this so I hope someone can help.
I am trying to use the above code to bring up a message when someone tries to close the workbook.
I can't get it to work.
I already have a module 1 so would you place this in module 2(which I have tried )
If someone could go through it step by step would be a great help.
The message that I want to come up is "Have you Protected the Sheets"
with the option to comfirm or return .

Cheers

aceuk

Quote:

Originally Posted by aceuk

Hi
I am a real novice at this so I hope someone can help.
I am trying to use the above code to bring up a message when someone tries to close the workbook.
I can't get it to work.
I already have a module 1 so would you place this in module 2(which I have tried )
If someone could go through it step by step would be a great help.
The message that I want to come up is "Have you Protected the Sheets"
with the option to comfirm or return .

Cheers

Just managed to work it out
So I'm ok
Cheers

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
how cani multiply cosine of an angle with a number,Ex cos60*2	formula calculation	New Users to Excel	1	February 20th 07 06:05 PM
i enter a lot of data in xl. cani create a form	nk suresh	Excel Discussion (Misc queries)	1	November 4th 06 11:36 AM
Reminder in Excel?	Gary	Excel Worksheet Functions	2	September 27th 06 10:26 PM
Turn Off save prompt, reminder when closing modified WORD...	S. Nyman	New Users to Excel	5	June 30th 06 01:23 PM
How canI view excel files on the taskbar?	Bert	Excel Discussion (Misc queries)	2	August 22nd 05 05:44 PM

Menu

About Us