Creating a pop up window.

drag-driver

Board Regular
Joined
Feb 18, 2002
Messages
91
What i need to do is----------create a pop up window which apears every time the file is opened telling the person whats the settings on the file is.
 

Excel Facts

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.
No worries, put this into the workbook open event:


Private Sub Workbook_Open()

MsgBox "Don't forget that this workbook has a special code which enables this message box"

End Sub



If you want it for every worksheet, try this:

Private Sub Worksheet_Activate()

If Range("A1").Value<> "off" Then MsgBox "Don't forget that this sheet has a special code which enables this message box"

End Sub

Now if you want to disable it for some sheets, just put any number in A1 of that sheet

Hope this helps
This message was edited by Audiojoe on 2002-03-20 08:18
 
Upvote 0
Righto,

Go into your workbook and press ALT+F11. Now on the left it should have icons for SHeet1, Sheet2, Sheet3 and This Workbook

Double click "This Workbook", then at the top of the blank page you'll see two drop down boxes. One says General, and the other one says Declarations. You change the General one to 'Workbook' and paste the code onto the blank page
 
Upvote 0
Put it in thisworkbook code right click on the excel icon, top left next to file then view code
 
Upvote 0
how can i make this message box which apears show the current settings ie when someone has made shanges to the setiings saved and exits and the next person who uses the program will want to know what the new settings wíll be, i want the message box to show the current settings, ie referance to cells which have the possibilyty of being changed
 
Upvote 0

Forum statistics

Threads
1,213,527
Messages
6,114,150
Members
448,552
Latest member
WORKINGWITHNOLEADER

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
Back
Top