Automated Popup on Opening of a Spreadsheet
 

Good Day,

I would like a popup screen to come up automatically when a spreadsheet is
open. This popup will provide directions to the users of the spreadsheet. (I
have a second sheet that provides directions but, I would like to emphasize a
couple points. I hope this is a feature within Excel but, I wouldnt be
surprised if I need to use VBA code to make it happen. Any suggestions,
would be greatly appreciated.

Thanks,

Brad

Automated Popup on Opening of a Spreadsheet
 

You can have comments in cells that pop up. You can set validation in cells
which includes a pop up. But there is no workbook level popup capability
inherent in Excel. You can use VBA code to put up a "splash screen"


John Walkenbach shows one way:
http://www.j-walk.com/ss/excel/tips/tip39.htm

--
Regards,
Tom Ogilvy



"Brad.R.Sutton" wrote:

Good Day,

I would like a popup screen to come up automatically when a spreadsheet is
open. This popup will provide directions to the users of the spreadsheet. (I
have a second sheet that provides directions but, I would like to emphasize a
couple points. I hope this is a feature within Excel but, I wouldnt be
surprised if I need to use VBA code to make it happen. Any suggestions,
would be greatly appreciated.

Thanks,

Brad

Automated Popup on Opening of a Spreadsheet
 

I dont know if this is a feature within excel, but if you want to fit a
fair bit of information on the 'pop-up' screen then I would use vba,
create a userform and just put all the information on it that you want
people to see, in the workbook_open put "userform1.show" , on the
userform you will need to include a "close" or "finish" button to get
rid of the form and behind the button all you need is "unload
userform1"

so not much vba code really but again, i dont know if this is a feature
of excel already

HTH

Duncan

Automated Popup on Opening of a Spreadsheet
 

Thank You Duncan,

Your help is appreciated.

Regards,
Brad

"Duncan" wrote:

I dont know if this is a feature within excel, but if you want to fit a
fair bit of information on the 'pop-up' screen then I would use vba,
create a userform and just put all the information on it that you want
people to see, in the workbook_open put "userform1.show" , on the
userform you will need to include a "close" or "finish" button to get
rid of the form and behind the button all you need is "unload
userform1"

so not much vba code really but again, i dont know if this is a feature
of excel already

HTH

Duncan

Automated Popup on Opening of a Spreadsheet
 

Thank You Tom,

This definately helped.

Best Regards,
Brd

"Tom Ogilvy" wrote:

You can have comments in cells that pop up. You can set validation in cells
which includes a pop up. But there is no workbook level popup capability
inherent in Excel. You can use VBA code to put up a "splash screen"


John Walkenbach shows one way:
http://www.j-walk.com/ss/excel/tips/tip39.htm

--
Regards,
Tom Ogilvy



"Brad.R.Sutton" wrote:

Good Day,

I would like a popup screen to come up automatically when a spreadsheet is
open. This popup will provide directions to the users of the spreadsheet. (I
have a second sheet that provides directions but, I would like to emphasize a
couple points. I hope this is a feature within Excel but, I wouldnt be
surprised if I need to use VBA code to make it happen. Any suggestions,
would be greatly appreciated.

Thanks,

Brad